Which of the following is the correct schema format for a Time column?

Which statement is TRUE?

Record Count property is set to zero in Connector stage. How many rows are written out?

Which partitioning method requires a key?

When you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL,
which of the following is the correct option?

Which of the following statements about checkpoint/restart is TRUE?

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.)