Skip to Content
avatar image
Former Member

SAP BODS Incremental Load

Hello All, I am loading data from legacy ssystem and implementing SCD2 .If i run job after Initial load, count is increasing even when there are no changes in Source system. I am suppose to take CUST_ID as primary key , Can anyone tel me how to implement SCD2 for this below table.

If i change any one of CUST_ID eg: C100 -CUST_TEL_NR - 9491959094 to -1234567890 when i run job for this changed records all the records of C100 are getting updated END-DATE (Today date ) and new records are getting updated with 12.31.999 .

Regrds Vinay

sdn.jpg (35.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Former Member

    1.Could you check the primary key columns and comparison columns in your table comparison transform.

    2.Check whether you are using the key generation transform to generate surrogate keys.



  • Get RSS Feed

1 Answer