Skip to Content
0

SAP BODS Incremental Load

Jan 10, 2017 at 11:50 PM

501

avatar image
Former Member

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)
10 |10000 characters needed characters left 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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jan 11, 2017 at 02:55 PM
0

Hi.

Above table is my Staging table which we are not using any logic, it is extract everything from Source.

IN my Target Table i am using ROWID(int) and FLAG(Varchar) , i am using CUST_ID as PK in Table comparison and

ROWID in key gen transform.

Regards

Vinay

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

You will have to use Table Comparison delta method. I have replied to your another post

https://answers.sap.com/questions/102224/sap-bods-scd2-loading-issues.html?childToView=102743#answer-102743

Target-based CDC extracts all the data from the source, compares the source and target rows using table comparison and then loads only the changed rows into the target system.

https://wiki.scn.sap.com/wiki/display/EIM/Delta+Load+Implementation

Refer to below which will give you the exact steps:

https://blogs.sap.com/2011/08/04/target-based-change-data-capture-using-business-objects-data-services/

Regards

Arun Sasi

0