Skip to Content

Some doubts on History Preservation in BODS

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 26 at 11:10 AM

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

    Add comment
    10|10000 characters needed characters exceeded