Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 13, 2018 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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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'.