- All Exams Instant Download
What operations can be pushed down in SAP Data Services?
What operations can be pushed down in SAP Data Services?A . Aggregation operations used with a group by statementB . join operations between a file and a database tableC . Load operations that contain triggerD . Join operations between sources that are on the same database serversView AnswerAnswer: D
Where can you see the order that the dataflows were executed in?
An SAP data services job was executed in the past. Where can you see the order that the dataflows were executed in? There are 2 correct answers to this question.A . In the operational dashboardB . In the impact and Lineage Analysis reportC . In the job trace log.D ....
An SAP Data Services dataflow has validation error. What is the cause?
An SAP Data Services dataflow has validation error. What is the cause?A . The dataflow has a syntax error that has to be correct before executing it.B . The source data does NOT comply with the rules entered in the Validation transformC . The source data is incorrect and the...
What does the expression SUBSTR(FIRST NAME, 1,3) return?
What does the expression SUBSTR(FIRST NAME, 1,3) return?A . UB . MC . FIRD . IRSView AnswerAnswer: C
A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?
A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either 'Yes' or 'No'. How do you assign the value to the $NEEDS_RECOVERY variable?A . Use a script with an SQL function...
You built a delta load dataflow in SAP Data Services. This Dataflow is executed every night. The source table contains a CHANGE_DATE column
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 columnA...
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
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 bottleneckA . On the view data tabB . In the impact and...
How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?
How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?A . by setting the target table loader with Bulk Load and Auto Correct Load enabled.B . by setting the target table loader with bulk load enabledC . By using the...
S ervices?
What transform can you use to change the operation code from UPDATE to INSERT in SAP Data S ervices? Note: There are 2 correct answers to this questionA . queryB . Key generationC . Map operationD . History PreservingView AnswerAnswer: C,D
In SAP Data Services why would you select the produce default output checkbox in the Case transform?
In SAP Data Services why would you select the produce default output checkbox in the Case transform?A . To output all rows that match the case statementB . to output all rows that do match exactly one case expressionC . To output all rows to the default path regardless if...
