资讯

TechRepublic3 年

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.