Patent Document ID: 9031902
Application ID: 13293196
Patent Flag: 1

Claim One:
1. 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 each SCD attribute is associated with a set of conditions for values of that SCD attribute, wherein an SCD type for a dimension contains a corresponding set of SCD attributes, and wherein the identifying one or more attributes in the data model as SCD attributes comprises: determining a similarity score measuring the similarity of an attribute name for an attribute in the plurality of attributes with a stored attribute name; and when the similarity score is above a predetermined threshold score, identifying the attribute as an SCD attribute; identify the SCD type for each dimension in the data model with identified SCD attributes by comparing the identified SCD attributes in the data model for that dimension with the corresponding sets of SCD attributes associated with the SCD types; verify the identified SCD attributes against the associated sets of conditions by comparing values for each identified SCD attribute from a data source to at least one of each other and a reference value to determine compliance of that identified SCD attribute with the corresponding set of conditions; 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.