IBM InfoSphere DataStage v9.1 Sample Questions:

1. Identify the two statements that are true about the functionality of the XML Pack 3.0. (Choose two.)

A) XML Stage can be found in the Database folder on the palette.
B) A single XML Stage, which can be used as a source, target, or transformation.
C) Uses a unique custom GUI interface called the Assembly Editor.
D) XML Stages are Plug-in stages.
E) It includes the XML Input, XML Output, and XML Transformer stages.

2. In your ETL application design you have found several areas of common processing requirements in the mapping specifications. These common logic areas found include: code validation lookups and name formatting. The common logic areas have the same logic, but the jobs using them would have different column metadata. Choose the action that gives you the best reusability design to effectively implement these common logic areas in your ETL application?

A) Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.
B) Create parallel shared containers and define columns combining all data formats.
C) Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.
D) Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.

3. 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_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".
D) 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".

4. On the DataStage development server, you have been making enhancements to a copy of a DataStage job running on the production server. You have been asked to document the changes you have made to the job. What tool in DataStage Designer would you use?

A) Cross Project Compare
B) diffapicmdline.exe
C) DSMakeJobReport
D) Compare Against

5. Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?

A) Overwrites an attribute in the fact table.
B) Overwrites an attribute in a dimension table.
C) Adds a new row to the fact table.
D) Adds a new row to a dimension table.

Solutions: