Slowly changing dimension attributes in extract, transform, load processes

A computer program product for identifying and handling slowly changing dimension (SCD) attributes for use with an Extract, Transform, Load (ETL) process, comprising:

• a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising computer readable program code configured to:
• import 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;
• analyze the data model and identify, 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;
• import the identified SCD attributes into the data integration system;
• select a data source comprising dimensional data;
• automatically generate an ETL job for the dimensional data utilizing the imported SCD attributes;
• and
• execute the automatically generated ETL job to extract the dimensional data from the data source and load the dimensional data into the imported SCD attributes in a target data system.

A system for identifying and handling slowly changing dimension (SCD) attributes for use with an Extract, Transform, Load (ETL) process, comprising:

• a memory;
• and
• a processor configured with logic to:
• import a data model for dimensional data, wherein the dimensional data comprises a plurality of attributes for one or more dimensions;
• store the data model in the memory;
• analyze the data model and identify, 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;
• store the identified SCD attributes in the memory;
• select a data source comprising dimensional data;
• automatically generate an ETL job for the dimensional data utilizing the stored SCD attributes;
• and
• execute the automatically generated ETL job to extract the dimensional data from the data source and load the dimensional data into the stored SCD attributes in a target data system.