SAP
C_DS_42 · Question #32
When evaluating the customer data for Alpha Acquisitions, you discover a data entry error. The contact title of "Account Manager" has been entered as "Accounting Manager". You must correct these…
The correct answer is B. In the Query Editor , in the Mapping tab, choose Functions. C. In the Select Function dialog box, choose String Functions . D. From the list of function names, select search_replace and choose Next. See the full explanation below for the reasoning.
Question
When evaluating the customer data for Alpha Acquisitions, you discover a data entry error. The contact title of "Account Manager" has been entered as "Accounting Manager". You must correct these entries before it is moved to the data warehouse. How to Using the Function wizard, create a new expression for the column using the search_replace function found under the category of "String" functions?
Options
- ATo delete existing expression, in the Mapping tab highlight the expression and press the Delete
- BIn the Query Editor , in the Mapping tab, choose Functions.
- CIn the Select Function dialog box, choose String Functions .
- DFrom the list of function names, select search_replace and choose Next .
How the community answered
(50 responses)- A20% (10)
- B80% (40)
Community Discussion
No community discussion yet for this question.