SCD Type 1

Type 1 Slowly Changing Dimension data warehouse architecture applies when no history is kept in the database. The new, changed data simply overwrites old entries. This approach is used quite often with data which change over the time and it is caused by correcting data quality errors (misspells, data consolidations, trimming spaces, language specific characters).
Type 1 SCD is easy to maintain and used mainly when losing the ability to track the old history is not an issue.

SCD 1 implementation in Datastage

The job described and depicted below shows how to implement SCD Type 1 in Datastage. It is one of many possible designs which can implement this dimension. The example is based on the customers load into a data warehouse

Datastage SCD1 job design

A T001_Lookups transformer does a lookup into a hashed file and maps new and old values to separate columns.

SCD1 Transformer mapping

A T002 transformer updates old values with new ones without concerning about the overwritten data.

SCD1 Transformer update old entries