Data Warehousing Concept Using ETL Process for SCD Type-2

Download Now
Provided by: American journal of Engineering Research (AJER)
Topic: Data Management
Format: PDF
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.
Download Now

Find By Topic