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.

Subscribe to the Data Insider Newsletter

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays

Subscribe to the Data Insider Newsletter

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more. Delivered Mondays and Thursdays

Resource Details

Provided by:
International Journal of Emerging Trends & Technology in Computer Science (IJETTCS)
Topic:
Data Management
Format:
PDF