SAP Exam C_DS_42 Topic 11 Question 62 Discussion

Actual exam question for SAP's C_DS_42 exam

Question #: 62
Topic #: 11

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?

AUse twelve query transform to create the desired output. Then combine these transforms.

BUse the query transform with multiple IFTHENELSE() functions.

CUse the merge transform that is connected to the source

DUse the pivot transform with two pivot sets.

Show Suggested Answer

Suggested Answer: D

by Tammara at Mar 10, 2024, 04:59 PM

Limited Time Offer

25%

Off

Get Premium C_DS_42 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

German

1 days ago

I think the best way is to use the pivot transform with two pivot sets.

upvoted 0 times

...