PrepAway - Latest Free Exam Questions & Answers

Choose the action that gives you the best reusability design to effectively implement these common logic areas

In your ETL application design you have found several areas of common processing requirements
in the mapping specifications. These common logic areas found include: code validation lookups
and name formatting. The common logic areas have the same logic, but the jobs using them
would have different column metadata. Choose the action that gives you the best reusability
design to effectively implement these common logic areas in your ETL application?

PrepAway - Latest Free Exam Questions & Answers

A.
Create parallel routines for each of the common logic areas and for each of the unique column
metadata formats.

B.
Create separate jobs for each layout and choose the appropriate job to run within a job
sequencer.

C.
Create parallel shared containers and define columns combining all data formats.

D.
Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only
necessary common columns needed for the
logic.

Explanation:


Leave a Reply