Some doubts on History Preservation in BODS

[former_member530332]

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 ?

[former_member208402 · Accepted solution]

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

[former_member530332 · Accepted solution]

Hi Ravi , If opcode DELETE will be Deleted , then what will be the purpose for using History Preservation, as the record gets DELETED ? I am bit Confused now , please brief me more ? thanks

[former_member208402 · Accepted solution]

Hello Prashanth,

In this case you have to uncheck "detect deleted records from comparioson table" option in Table_comparison transform, so that deleted rows wont be passed to history preservartion. If you would like to store deleted rows in the target. Then check "detect deleted records from comparioson table" option in Table_comparison transform and also check "preserve deleted rows as update rows" option in history preservation transform.

[former_member530332 · Accepted solution]

Thanks Ravi, the information you shared is so helpful for me.