American journal of Engineering Research (AJER)
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.