Free SAP C_DS_43 Exam Dumps Questions & Answers

You source table has a revenue column and a quantity column for each month. You want to transform this data to get a table containing twelve rows whit two columns.
What is the best way to achieve this in SAP Data services?

• A.Use the query transform with multiple IFTHENELSE() functions.
• B.Use the pivot transform with two pivot sets.
• C.Use twelve query transform to create the desired output. Then combine these transforms.
• D.Use the merge transform that is connected to the source

You executed a job in development environment and it raised primary key violation error in SAP Data Services. Which feature do you enable to identify which primary key values caused the errors?

• A.Auto correct load
• B.delete data before loading
• C.Use overflow file
• D.Drop and re-created target table

You want to set up a new SAP Data Services landscape. You must also create new repositories. Which repository types can you create?

• A.Central repository
• B.Backup repository
• C.Profiler repository
• D.Local repository
• E.Standy repository

How do you desing a data load that has good performance and deals with interrupted loads in SAP Data services?

• A.By creating two dataflows and executing the Auto Correct Load version when reired
• B.by setting the target table loader with bulk load enabled
• C.By using the table comparison transform
• D.by setting the target table loader with Bulk Load and Auto Correct Load enabled.

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.Use a regular lookup function
• B.Join the two tables
• C.Perform an outer join between both tables
• D.Use a lookup_ext function