Patent Document ID: 9311368
Application ID: 13618158
Patent Flag: 1

Claim One:
1. A computer-implemented method of identifying and handling slowly changing dimension (SCD) attributes for use with an Extract, Transform, Load (ETL) process, comprising: importing a data model for dimensional data into a data integration system, wherein the dimensional data comprises a plurality of attributes for one or more dimensions; analyzing the data model and identifying, via a data discovery analyzer, one or more attributes in the data model as SCD attributes, wherein the identifying includes identifying at least one attribute in the data model as an SCD attribute based on a comparison of a name of the at least one attribute to a stored set of names used for SCD attributes; importing the identified SCD attributes into the data integration system; selecting a data source comprising dimensional data; automatically generating an ETL job for the dimensional data utilizing the imported SCD attributes; and executing the automatically generated ETL job to extract the dimensional data from the data source and loading the dimensional data into the imported SCD attributes in a target data system.