IBM InfoSphere DataStage v9.1 Sample Questions:

1. Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?

A) Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
B) Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".
C) Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
D) Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".

2. You have created three parallel jobs (Job A, B and C) in which the output of one job is the input to the other job. You are required to create processing that manages this data relationship of the jobs and provide job level restart-ability. What two tasks will accomplish these objectives? (Choose two.)

A) Set the 'Add checkpoints so sequence is restartable' option in the Sequencer job.
B) Enable the 'Add checkpoints so container is restartable' option for each of the parallel shared containers.
C) Enable runtime column propagation for the job sequence running the jobs.
D) Create two parallel shared containers that has the logic of Job B and Job C and include those shared containers in the correct flow order within the design of Job A.
E) Create a Sequencer job that has triggered events configured allowing Job A to run first, then Job B to run when A completes successfully, and then Job C to run when Job B completes successfully.

3. In a Transformer expression for a stage variable, there is a nullable input column. Assume the legacy NULL processing option is turned off. What happens when a row is processed that contains NULL in that input column?

A) The row is rejected.
B) NULL is written to the stage variable.
C) The job aborts.
D) The value written to the stage variable is undetermined.

4. You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed. What are two requirements on the input link data for the Change Capture stage? (Choose two.)

A) parallel mode
B) key partitioned
C) sorted
D) merged links
E) sequential mode

5. 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?

A) Name all stage and links the same.
B) Name all stage and links with column names and ideas.
C) Name all stages and links based on what they do.
D) Indicate all stage names within the job annotation.

Solutions: