You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services?

You want to display the description of an object in the Designer workspace-Which task must you perform to accomplish this in SAP Data services? 3 correct answersA . Click the view enabled descriptions button on the toolbar.B . Enter a description in the properties of the object.C . right-click the...

April 16, 2024 No Comments READ MORE +

How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed?

An SAP Data Services dataflow adds the changed data (insert and update) into a target table every day. How do you design the dataflow to ensure that a partially executed dataflow recovers automatically the next time it is executed? 2 correct answersA . Enable the Delete data before load target...

April 16, 2024 No Comments READ MORE +

Which transform do you use?

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?A . Map_Operation transformB . Validation transformC . Case transformD . Country ID transformView AnswerAnswer: C

April 15, 2024 No Comments READ MORE +

How can you see which part of the operations is pushed down to the source database?

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 . by opening the auto documentation page in the Data Services Management ConsoleB ....

April 13, 2024 No Comments READ MORE +

How would you expect the system to behave when you run the job in recovery mode?

You SAP Data Services job design includes an initialization script that truncates rows in the target prior to loading, the job uses automatic recovery How would you expect the system to behave when you run the job in recovery mode? Note: There are 2 correct answers to this questionA ....

April 12, 2024 No Comments READ MORE +

What can you use a workflow for in SAP Data Services?

What can you use a workflow for in SAP Data Services?A . To group data flows that belong togetherB . To group jobs that you want to monitorC . to allow schedulling for dataflowsD . To transform source data into target dataView AnswerAnswer: A

April 11, 2024 No Comments READ MORE +

In SAP Data Services what do you use implement a target-based delta that deals with inserts, update and deletes in the source.

In SAP Data Services what do you use implement a target-based delta that deals with inserts, update and deletes in the source.A . Table comparison transformB . A Map_CDC_Operation transformC . The auto correct loadD . A Map_Operation transformView AnswerAnswer: B

April 10, 2024 No Comments READ MORE +

Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answers

Which type of SAP Data Services object can a project, job, dataflow or workflow contain? 3 correct answersA . A Project can contain a jobB . A job can contain a jobC . A dataflow can contain a workflowD . A job can contain a workflowE . A workflow can...

April 10, 2024 No Comments READ MORE +

How do you view the data between transforms in SAP Data Services dataflow?

How do you view the data between transforms in SAP Data Services dataflow?A . By setting the Audit Data On job execution trace optionB . By using the interactive debuggerC . By setting the SQL Transforms on job execution trace optionD . By adding audit points in the dataflowView AnswerAnswer:...

April 10, 2024 No Comments READ MORE +

In SAP Data Services which basic operations can you perform with a Query transform?

In SAP Data Services which basic operations can you perform with a Query transform?A . "Join data from several sources"B . "Apply functions to columns"C . Map Columns from an input schema to an output schema"D . Flag rows for updateE . Set a global variable to a valueView AnswerAnswer:...

April 9, 2024 No Comments READ MORE +