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.

    Regards,

    Prasanna

  • Get RSS Feed

1 Answer