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?

When optimizing a job, Balanced Optimization will NOT search the job for what pattern?

You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator
and a left outer join on the ZIP code column. Currently all partitioning is set to “Auto” and
automatic sort insertion is allowed.

Which change will reduce the cost of partitioning that occurs in this job?

You have a parallel job that based on operational recoverability requirements needs to be broken
up into two separate parallel jobs. You have decided to use the Data Set stage to support this job
design change. What two characteristics of Data Sets make them a good design consideration in
your jobs design change? (Choose two.)

What two binding types are supported by Information Services Director (ISD) for a parallel job that
is designed to be used as a service? (Choose two.)

You are assigned to correct a job from another developer. The job contains 20 stages sourcing
data from two Data Sets and many sequential files. The annotation in the job indicates who wrote
the job and when, not the objective of the job. All link and stage names use the default names.
One of the output columns has an incorrect value which should have been obtained using a
lookup. What could the original developer have done to make this task easier for maintenance
purposes?

You are asked by management to document all jobs written to make future maintenance easier.
Which statement is true about annotations?

A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer
stage and an output Sequential File stage. The job is run on an SMP machine with a configuration
file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True. How
many player processes will this job generate?

Which partitioning method requires a key?

A job design consists of an input Row Generator stage, a Sort stage, followed by a Transformer
stage and an output Data Set stage. The job is run on an SMP machine with a configuration file
defined with four nodes. The $APT_DISABLE_COMBINATION variable is set to True. How many
player processes will this job generate?