An SAP Data Services Validation transform outputs all invalid rows. If more than ten rows are invalid, the data is considered to be failed. How do you implement this?
You developed a batch job using SAP Data Services and want yo start an execution. How can you execute the job?
2 correct answers
Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers
You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM
How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?
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 transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers
Why would you use a memory datastore in your SAP Data Services dataflow design?