Skip to Content
0

Some doubts on History Preservation in BODS

Feb 23 at 09:15 AM

56

avatar image

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 ?

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 26 at 11:10 AM
1

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

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

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

0

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.

2

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

0