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?
A. 8
B. 10
C. 12
D. 16
Which partitioning method requires a key?
A. Same
B. Modulus
C. Sort Merge
D. Round Robin
The Score is divided into which two sections? (Choose two.)
A. Stages
B. File sets
C. Schemas
D. Data sets
E. Operators
Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?
A. Set $APT_DUMP_SCORE to true.
B. Set $APT_PM_SHOW_PIDS to true.
C. Log onto the server and issue the command "ps -ef | grep ds".
D. Use the DataStage Director Job administration screen to display active player processes.
In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)
A. Database
B. Host system
C. Project name
D. Database instance
E. DataStage server system name
Which derivations are executed first in the Transformer stage?
A. Input column derivations
B. Loop variable derivations
C. Stage variable derivations
D. Output column derivations
How does the Complex Flat File stage (CFF) support the use of OCCURS clauses within COBOL files?
A. Each element of the OCCURS clause is treated as a subrecord.
B. The CFF stage cannot process COBOL files with OCCURS clauses.
C. Each element of the OCCURS clause is treated as a column of raw data.
D. Each element of the OCCURS clause is treated as a separate element in an array.
What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)
A. FTP
B. EFTP
C. TFTP
D. SFTP
E. RFTP
What are the valid join operations for the Join stage? (Choose two.)
A. Inner join
B. Where join
C. Top outer join
D. Right outer join
E. Bottom inner join
Click the Exhibit button.
The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime metadata may help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)
A. Director job monitor tool.
B. Designer Performance Analyzer tool.
C. Designer "Show performance statistics" option.
D. The view data button in the target Connector stage.
E. InfoSphere Metadata Asset Manager (IMAM) operational metadata reports.
