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?
The performance of a dataflow is slow in SAP Data Services. How can you see which part of the operations is pushed down to the source database? Note: the are 2 correct answers to this question.
A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSION. For example: POSTECODE:99999 EXTENSION: 9999 Desired result is ZIP4:99999-9999