delete records in history preserving

dataservices job design
1

Hi Guru,

Please advice, I need help with a solution in handling delete records.

I trying to implement solution by using this thread https://blogs.sap.com/2015/07/13/history-preserving-with-millisecond-precise-timestamps/

But in my scenario the source is daily generated file with a column that defines the row with A,U,D ( add,update,delete ). How do I handle the delete records in the target because blog explains table-table comparison but in my scenario when there is a delete in source then the deleted record with be flagged as “D” )

RUC :us: (BOB member since 2010-05-03)

2

Table comparison is used just to flag records. You can do the same with map operation.

In brief:

  1. split your incoming records in 3 different flows, depending on your operation flag (A, U, D)

2.1. those flowing to “A” are already set, so leave them where they are until item 3;
2.2. those flowing to “U” or “D” branches enter a dedicated “map operation” component, where you set “normal to update” on “U” branch and “normal to delete” on “D” branch.

  1. merge the 3 flows into one with a “merge” component and send the unified flow as if it were the output of the blog thread’s table comparison.

CLS69 :it: (BOB member since 2009-06-11)