A DataStage job uses an Inner Join to combine data from two source parallel datasets that were
written to disk in sort order based on the join key columns. Which two methods could be used to
dramatically improve performance of this job? (Choose two.)

Which two statements are true regarding access to a MQ queue? (Choose two.)

What conditions are necessary for a master record and an update record to merge?

Configuring the weighting column of an Aggregator stage affects which three options. (Choose
three.)

In which two situations would you use the Web Services Client stage? (Choose two.)

What stage allows for more than one reject link?

A customer requires that a single output file generated by a parallel job be created in sort order.
Which two job designs would achieve this goal? (Choose two.)

What are two fundamental functions of the Information Server Source Code Integration based on
the Eclipse Team framework? (Choose two.)

You have been asked to assess the impact of replacing the DB2 Enterprise Stage with the DB2
Connector. You must identify all of the jobs and shared containers that use the DB2 Enterprise
Stage.
What two Advanced Find criteria would you set to identify the jobs and containers? (Choose two.)

You are asked to identify the jobs and shared containers that use the ADDRESS column. The Size
has changed from 50 to 120 characters in the source system so the jobs must be updated with the
new size. What feature of the Designer will locate where a column is used in a DataStage project?