Free SAP C-DS-43 Exam Dumps Questions & Answers

You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?

• A.  Join the two tables
• B.  Use a lookup_ext function
• C.  Use a regular lookup function
• D.  Perform an outer join between both tables

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?

• A.  Is is rerun with the first failed row.
• B.  It is rerun from the beginning and the desing of the data flow must deal with partially loaded data.
• C.  It is rerun only if the dataflow is part of a recovery unit.
• D.  It is rerun from the beginning and the partially loaded data is always handled automanticaly.

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 starting the job in debubg mode.
• B.  by opening the auto documentation page in the Data Services Management Console
• C.  By enabling corresponding trace options in the job execution dialog.
• D.  By opening the dataflow and using the view optimized SQL feature.

An SAP data services file format has a date column, but occasionally the file contains an invalid value in one row. This causes the dataflow to terminate with an error.
What can you do to completely load such erroneous files?
Note: There are 2 correct answer

• A.  Use the error handling options for conversion error in the file format definition
• B.  Place the dataflow between a Try/Catch block to catch all erroneous rows
• C.  Define the column as varchar and use functions in subsequent Query transform to perform the checks and conversion
• D.  Specify a date format of'????-??-??' to indicate the value might NOT be a valid date in the file format editor

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?

• A.  They are filtered by the transform
• B.  They are deleted from the target
• C.  They are added to the overflow file
• D.  They are flagged for later deletion