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?

A Map operation transform in SAP Data Services was used to modify the operation code of data is being processed. Why do you perform this action?

which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers

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?

What operations can be pushed down in SAP Data Services?