what pattern?
When optimizing a job, Balanced Optimization will NOT search the job for what pattern?
What three requirements must be met in order to use this stage?
You are required to use a Make Vector stage in your job. What three requirements must be met in
order to use this stage? (Choose three.)
Which change will reduce the cost of partitioning that occurs in this job?
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?
What two tasks must be done to meet these requirements?
A customer requires reading a fixed-length sequential file in parallel where input rows can be
identified. What two tasks must be done to meet these requirements? (Choose two.)
What two characteristics of Data Sets make them a good design consideration in your jobs design change?
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.)
Which three source stages require a schema file when using RCP?
Which three source stages require a schema file when using RCP? (Choose three.)
What two binding types are supported by Information Services Director (ISD) for a parallel job that is designe
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.)
Which approach will retrieve and process all five files in the minimal amount of time?
A client has multiple servers connected with a high bandwidth switch and has installed DataStage
on one of them. There are five files (with the same record layout) that must be retrieved from three
other servers using FTP. Which approach will retrieve and process all five files in the minimal
amount of time?
What could the original developer have done to make this task easier for maintenance purposes?
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?
Which three statements are true about File Sets?
Which three statements are true about File Sets? (Choose three.)