Data Warehousing Concept Using ETL Process For SCD Type-1
Kannan Srikanth, Nistala V. E. S. Murthy, J. Anitha, M. Tech · 2012
A Type 1 change overwrites an existing dimensional attribute with new information. In the customer name-change example, the new name overwrites the old name, and the value for the old version is lost. A Type One change updates only the attribute, doesn't insert new records, and affects no keys. The new incoming record (changed/modified data set) replaces the existing old record in target. It is easy to implement but does not maintain any history of prior attribute values. Slowly Changing Dimensions (SCDs) are dimensions that have data that changes slowly, rather than changing on a time-based, regular schedule. Keywords- ETL; Metadata; Mapping; Transformation. I.