Data Warehousing Concept Using ETL Process for SCD Type-3
In this approach, only the information about a previous value of a dimension is written into the database. An ‘Old ‘or ‘Previous’ column is created which stores the immediate previous attribute. The problem with this approach is over years, if the product price continuously changes, then the complete history may not be stored, only the latest change will be stored. Slowly Changing Dimension Type 3 preserves only few history versions of data, most of the time ‘Current’ and Previous’ versions. The ‘Previous’ version value will be stored into the additional columns with in the same dimension record. In this paper let’s discuss the step by step implementation of SCD Type 3 using Informatica Power Center.