C_DS_42 · Question #34
In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced with a code. To speed up access to information in the data warehouse, this lookup should…
The correct answer is C. the Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query D. In the Query Editor, in the output schema, choose the field Country. E. In the Mapping tab for the Country field, delete the existing expression. See the full explanation below for the reasoning.
Question
In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced with a code. To speed up access to information in the data warehouse, this lookup should be eliminated. Use the lookup_ext function to exchange the ID for the country name in the customers table for Alpha with the actual value from the country table. How to In the Alpha_NACustomer_DF workspace, delete an existing expression for the Country column in the Query transform?
Options
- AIn the Mapping tab, choose Functions.
- BIn the Select Function dialog box, choose Lookup Functions.
- Cthe Alpha_NACustomer_DF workspace, to open the transform editor, double click the Query
- DIn the Query Editor, in the output schema, choose the field Country.
- EIn the Mapping tab for the Country field, delete the existing expression.
How the community answered
(28 responses)- A14% (4)
- B7% (2)
- C79% (22)
Community Discussion
No community discussion yet for this question.