Data Warehousing Concept Using ETL Process for SCD Type-2
SCD type 2 will store the entire history in the dimension table. In SCD type 2 effective date, the dimension table will have start-date and end-date as the fields. If the end-date is null, then it indicates the current row. Know more about Slowly Changing Dimensions (SCDs) concepts. The new incoming record (changed/modified data set) replaces the existing old record in target. The authors will see how to implement the SCD type 2 effective date in informatica.
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