SAP
C_DS_42 · Question #51
Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order. When a row passes one criteria, it should NOT be tested for the next criteria. How…
The correct answer is B. Use a Case transform with the Row Can Be True for One Case Only and Preserve Expression. See the full explanation below for the reasoning.
Question
Your customer has rules requiring that each row in the source be tested for certain criteria in a specific order. When a row passes one criteria, it should NOT be tested for the next criteria. How should this be implemented using SAP Data Services transforms? Please choose the correct answer.
Options
- AUse multiple Query transforms with one WHERE? clause per rule.
- BUse a Case transform with the Row Can Be True for One Case Only and Preserve Expression
- Cse a Case transform with the Produce Default Output with Label option enabled, and enable the
- DUse a Validation transform and add the rules in the proper order for each single column.
How the community answered
(54 responses)- A13% (7)
- B80% (43)
- C2% (1)
- D6% (3)
Community Discussion
No community discussion yet for this question.