Hi I am using the SCD Type 2 loader to load data into a target table. However when I run the transformation more than once without changing the data in the source (duplicated data), the target table has closes out some records and adds new records into the table when the expected result should be no change in target. I have already read and applied the solution from the a similar issue in https://communities.sas.com/t5/SAS-Data-Management/DI-studio-SCD-Type-2-close-out-records/td-p/150155# but I am still getting the same issue where duplicated data in the source is closing and adding new records in the target. I am using SAS version 4.901 Due to the sensitivity of the data I am unable to attach any sample data. Has anyone encountered this issue? Kind regards Zubair
... View more