How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?

An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day.

How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?

2 correct answers
A . Enable the Delete data before load target table loader option
B . Add lookup function in the where clause to filter out existing rows.
C . Set the autocorrect load option in the target table loader option
D . Use the table comparison transform before the table loader

View Answer

Answer: B,D