In SAP data services what does the date generation transform allow you to generate?
You execute an SAP data services job with enable recovery activated. One of the dataflows in the jobs raises an exception that interrupts the execution. You run the job again with Recover from last failed execution enabled. What happens to the data flow that raised the exception during the first execution?
In SAP Data Services what do you use implement a target-based delta that deals with inserts, update and deletes in the source.
You import a table from a database into a datastore.
Which information is added into the SAP Data Services repository?
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?
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?
You created and saved a database datastore in SAP Data Services. Which properties can you change in the Edit Datastore dialog box?
You want to use on SAP data services transform to split your source vendor data into three branches, based on the country code.
Which transform do you use?
You want to back up an SAP Data Services repository. How does the system store repositories?
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
What does the expression SUBSTR(FIRST NAME, 1,3) return?
Which of the following administrative tasks can you perform using the SAP Data Services Management Console?