Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

SAP Exam C_DS_42 Topic 11 Question 62 Discussion

Actual exam question for SAP's C_DS_42 exam
Question #: 62
Topic #: 11
[All C_DS_42 Questions]

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?

Show Suggested Answer Hide 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
Cristina
11 months ago
That could work too, but pivot transform seems more efficient in this case.
upvoted 0 times
...
Dorothea
11 months ago
I'm just imagining the poor developer who has to maintain that twelve query transform solution. Option D is the way to go, no doubt.
upvoted 0 times
Laurena
10 months ago
Option D) Use the pivot transform with two pivot sets.
upvoted 0 times
...
Kathrine
10 months ago
Option C) Use the merge transform that is connected to the source
upvoted 0 times
...
Denny
10 months ago
Option D) Use the pivot transform with two pivot sets.
upvoted 0 times
...
Francesco
10 months ago
Option B) Use the query transform with multiple IFTHENELSE() functions.
upvoted 0 times
...
Wilda
10 months ago
Option C) Use the merge transform that is connected to the source
upvoted 0 times
...
Sommer
10 months ago
Option B) Use the query transform with multiple IFTHENELSE() functions.
upvoted 0 times
...
Louvenia
10 months ago
Option A) Use twelve query transform to create the desired output. Then combine these transforms.
upvoted 0 times
...
Cammy
10 months ago
Option A) Use twelve query transform to create the desired output. Then combine these transforms.
upvoted 0 times
...
...
Timothy
11 months ago
But wouldn't it be easier to use twelve query transforms and then combine them?
upvoted 0 times
...
Joye
11 months ago
I agree with Cristina. Using pivot transform will make it easier to get the table with twelve rows and two columns.
upvoted 0 times
...
Leah
11 months ago
The IFTHENELSE() functions in option B could get pretty messy and hard to maintain. Pivot transform for the win!
upvoted 0 times
Nohemi
10 months ago
Pivot transform is definitely the way to go for this task.
upvoted 0 times
...
Stephaine
11 months ago
I agree, using IFTHENELSE() functions can be confusing.
upvoted 0 times
...
...
Cristina
11 months ago
I think the best way is to use the pivot transform with two pivot sets.
upvoted 0 times
...
Orville
11 months ago
I prefer using the merge transform connected to the source for better data integration.
upvoted 0 times
...
Serita
11 months ago
Haha, using twelve query transforms to create the output? That's just overkill. Option D is the clear winner in my opinion.
upvoted 0 times
Felicidad
11 months ago
I think using the pivot transform with two pivot sets is definitely the most efficient option.
upvoted 0 times
...
Emerson
11 months ago
I agree, using twelve query transforms seems like a lot of unnecessary work.
upvoted 0 times
...
...
Martha
12 months ago
I'm not sure about the merge transform in option C. Isn't that more for combining multiple inputs? I think the pivot transform is the way to go here.
upvoted 0 times
Hoa
11 months ago
I think using twelve query transforms and then combining them might be too complicated. The pivot transform sounds simpler.
upvoted 0 times
...
Edward
11 months ago
I agree, using the pivot transform with two pivot sets seems like the best option.
upvoted 0 times
...
...
Jamey
12 months ago
I agree, using the pivot transform would simplify the process.
upvoted 0 times
...
Stanton
12 months ago
Option D definitely looks the best. Using the pivot transform with two pivot sets is the most efficient way to get the desired output.
upvoted 0 times
Dortha
11 months ago
Using the pivot transform with two pivot sets is the most efficient way to get the desired output.
upvoted 0 times
...
Katina
12 months ago
Option D definitely looks the best.
upvoted 0 times
...
...
German
1 years ago
I think the best way is to use the pivot transform with two pivot sets.
upvoted 0 times
...

Save Cancel