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.

In this paper let’s discuss the step by step implementation of SCD Type 3 using Informatica Power Center.