From my understanding about your problem, you want to close out records with a singular load for more than one record with the same business key. I had the same issue and the way i solved On SCD Type 2 Loader. Tab "Change Tracking": - on VALID_FROM_DTTM put DATETIME() function; - on VALID_TO_DTTM put a date wich seems adequate for you, like '01JAN5999:00:00:00'DT; Tab "Mappings": - Map the column VALID_FROM_DTTM with the field from your input file. Tab "Options/SCD": - Allow Multiple Updates per Day - "YES" Hope it is usefull. APPereira.
... View more
