Append delete and insert

dataservices job design
1

Hi ,

I need to load data monthly wise to hana database using BODS. For this job condition is if
New records---- Append.
Existing record — delete and Insert.

The Target table is also used in other data flow with bulk load with append option.

Please let me know how I can achieve this requirement.

Thanks.

Jyotimoon (BOB member since 2017-07-17)

2

Possibly look to:

  1. Update instead of Delete+Insert
  2. Merge incoming data so you just have the single dataflow controlling what data is added/updated/deleted in the target table, or if not possible prevent the two different dataflows loading the same target table at the same time[/list]

Darth Services :uk: (BOB member since 2007-11-20)