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?

• A. Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.
• B. Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.
• 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.

You would like to pass values into parameters that will be used in a variety of downstream activity stages within a job sequence. What are two valid ways to do this? (Choose two.)

• A. Place a parameter set stage on the job sequence.
• B. Use the UserVariablesActivity stage to populate the local parameters from an outside source such as a file.
• C. Check the "Propagate Parameters" checkbox in the Sequence Job properties.
• D. Use local parameters.
• E. Add a Transformer stage variable to the job sequence canvas.

What stage allows for more than one reject link?

• A. Join stage
• B. Lookup stage
• C. Funnel stage
• D. Merge stage

Which two data repositories can be used for user authentication within the Information Server Suite? (Choose two.)

• A. IBM Information Server user directory
• B. Operations Console database
• C. IBM Metadata repository
• D. Standalone LDAP registry
• E. IIS Web Console

Identify the two delimiter areas available to be configured in the Sequential File format tab properties? (Choose two.)

• A. Null delimiter
• B. File delimiter
• C. Final delimiter
• D. End of group delimiter
• E. Field delimiter