Skip to Content

How to perform SCD type 1 without using Table Comparison ​in SAP BODS ?

Feb 13 at 09:09 AM


avatar image

also how it will perform opcodes without using Table Comparision Transform in SCD-1

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ravi kiran Pagidi Feb 13 at 04:40 PM

use auto correct load in target table options. in target options set auto corredt load to YES. or you can achieve this by left outer join with target table and use map_operation to perform insert/update.

in case of auto correct load you dont need to use map_operation as auto correct load itself does insert/update like merge in plsql.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks Ravi , now Cleared my Doubt , But one more doubt arises in my mind please clear it too ,

Suppose I have 3 records , after Table Comparison , one record as opcode 'INSERT' ,second record as opcode 'UPDATE' and say third record opcode 'DELETE' ,

And After History Preservation what will be the Opcode for these three Records ?


After History Preservation the opcode for 'INSERT' will be 'INSERT' and for

'UPDATE' History preservation generates 2 opcodes (1 INSERT and 1 UPDATE), INSERT is to insert the record as latest record and UPDATE is to update its old record and set its Active status to OLD record and updates VALID_TO date(History). and 'DELETE' will be 'DELETE'.