on 01-10-2017 11:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You will have to use Table Comparison delta method. I have replied to your another post
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:
Regards
Arun Sasi
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.