C_DS_42 · Question #35
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 B. To use the default execution properties, choose OK. C. To return to the job workspace, on the toolbar, choose the Back icon. D. To open the data flow workspace, double click the data flow. E. Right click the target table and choose View Data. 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 Execute the Alpha_NACustomer_Job with the default execution properties after saving all objects you have created?
Options
- AIn the Mapping tab, choose Functions.
- BTo use the default execution properties, choose OK.
- CTo return to the job workspace, on the toolbar, choose the Back icon.
- DTo open the data flow workspace, double click the data flow.
- ERight click the target table and choose View Data.
How the community answered
(30 responses)- A17% (5)
- B83% (25)
Community Discussion
No community discussion yet for this question.