You create a file format in SAP Data Services
What properties can you set for a column?
Note: There are 3 correct answers to this question.
What is the SAP Data services Dataflow auditing feature used for? Note: There are 2 correct answers to this question.
You modified an existing SAP data Services job. You notice that the run time is now longer then expected. Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck
The SAP Data services merge transform is used to combine two datasets; the first has 3000 rows and the second has 2000 rows. What are characteristics of the Merge transform? Note: there are 2 correct answers to this question
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers
You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column
which is populated by the database when the row is saved.
What can a timestamp based CDC aproach identify in the source based on this CHANGE_DATE column
Which features are supported by the SAP Data Services interactive debugger?
3 correct answers
A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example:
Desired result is ZIP4:99999-9999
From the account table you want to know how many accounts you have per account type. The ACCOUNT_TYPE is output along with an additional column COUNTER. The group by tab of the query transform is used with ACCOUNT_TYPE. Which mapping would you use for the COUNTER column in SAP Data Services?
You are joining tables using the query transform of SAP Data Services.
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
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers