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

What requirement must you meet when mapping an output column on the SAP Data Services query transform mapping tab?

• A.Every column of the output schema must have a mapping
• B.Primary keys in the input schema must be mapped to only one column in the output schema
• C.All columns of the input schema must be mapped to the output schema
• D.Each column in the output schema must be mapped to one or more columns in the input schema

You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use the Date Generation transform to create this. What options are available to control the output form the transform?

• A.Effective date column
• B.Julian format
• C.Increment
• D.end date

In SAP Data services which function delivers the same results an nested 1FTHENELSE functions?

• A.Literal
• B.Match_regex
• C.Match_Pattern
• D.Decode

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

• A.A Map_Operation transform
• B.Table comparison transform
• C.A Map_CDC_Operation transform
• D.The auto correct load

You are asked to perform either the initial load or delta load based on the value of a variable that is set at job execution How do you design this requirement in SAP Data services.

• A.Use a job containing a script with the if then else () function to test the variable value. Connect this script to the initial and delta u dataflow.
• B.Use a job containing a Case transform testing for the two possible conditions. Connect one case output to the initial dataflow and the other to the delta dataflow Use a job container the delta dataflow
• C.Set the job to call the initial and delta dataflow in parallel. Each dataflow should have a filter testing for the variable value.
• D.Use a job containing a Conditional objet that test the value of the variable. In the IF part, call the initial dataflow in the ELSE part call