How would you use the View Optimized SQL feature to optimize the SQL feature to optimize the performance of the dataflow?
You define audit rules for critical data flow to confirm that you SAP Data Services batch job loaded only correct dat a. Which audit functions are available to define these rules for columns? Note: There are 3 correct answers
In which of the following objects can you use built-in- functions in SAP Data services? Note: There are 3 correct answers to this question
What transform can you use to change the operation code from UPDATE to INSERT in SAP Data Services? Note: There are 2 correct answers to this question
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
which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers
In SAP Data services which function delivers the same results an nested 1FTHENELSE functions?
You have a map operation transform immediately before the target in a data flow in Sap Data Services. What happens if all operation codes are mapped to Discard in the transform?
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct