First time i am trying with SCD component. Just a hands on practice to know about the component.
I have a source table with 3 records, below are the list of records i have in the table,
when i applied the SCD to transfer the records to destination table, Type 1 and the business key is column1.
i am getting the following behaviour for the 2 continous execution,
First Run - inserting 3 records irrespective of validationg the repetation of column values.
second run - No change. I understand this, as there was no change in the records so no change in the table.
But for the first run i do not understand why its inserting all 3 records. As per my understanding, it should insert only one record.
Also i tried inserting one record manually(1,2,3) to the table and tried running the package, there was no change in the table. i understand this aswell, as there was no change in the records coming in.
Kindly clarify why for the first run alone, its inserting records without validating the repetation of records.
Thanks & Regards,