Which of the following will determine the running row number within a group?

Which of the following is an FTP Collection method?

Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed
by another DB2 Connector stage.
The following two Balanced Optimizer options have been selected:
– Push processing to data sources
– Push processing to data targets
The following two Balanced Optimizer options have NOT been selected:
– Push data reduction processing to data targets
– Push all processing into the(target)data server
Assuming the job design allows for maximum optimization, what does the optimized job design look like?

You are experiencing performance issues for a given job. You are assigned the task of understanding what is
happening at run time for that job. What steps should you take to understand the job performance issues?
(Choose two.)

When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

How do you create a shared table definition from the DataStage client?

Which of the following will run the DataStage job in the Unix environment for the domain is1:9445, server is1
for the user srv_etl?

Which restructure stage has a single reject link?

A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. We need
the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm
should
be chosen in the target Sequential File stage?

Which is NOT a valid native operator for OSH?