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.

As the number of types of slowly changing dimensions (SCDs) increased, things have ended with Types 0 through 7, making essentially eight of them. But it is unclear whether there full consensus exists ...