Transformation Flow, Init and Delta

[p_m8]

Hi,

1. In my Local Table (Employee Source), I have the Delta Capture option ON.

2. I use this as source table in my Transformation Flow and loaded into target table (Employee Target). I chose to load from table Delta Capture.

3. In the Employee Target table, I can see all records updated correctly, the field Change Type = I, Change Date = Sep 25, 2025, 3:51:01 

4. Now in Local Table (Employee Source), I updated one record only - Employee 123.

5. Run data load again via Transformation Flow, again, all records updated. I can see the Change Date field updated with current run date/time for all the records.

6. Why are all records updated again? I thought it is only Employee 123 will be updated as I chose load from table Delta Capture, not All Active Records??

Please advise, thanks.

[Martin_Kuma]

Hi,

check the keys in the source / target tables. 

You will probably have the date as key. Check the Change_Type for the record in the source and also in the target tables. When you manually change a field, you will see "U" (Update) there, not "I" (Insert). Then the transformation flow will update 1 record only, unless you the the field you updated as key. 

If your target table does not show the "U" in the Change_Type, but only "I", then it means that you are creating new rows and that implicates mismatch in the key of the source / target tables. 

Cheers,

Martin