IBM Websphere Datastage V.8.0 Sample Questions:

1. A parallel job combines rows from a source DB2 table with historical information maintained in two separate Oracle tables. Only rows in the DB2 source whose key values match either Oracle table are output to a target Teradata table. Both Oracle tables have identical column definitions and are stored in the same Oracle instance. Which two design techniques would satisfy this requirement? (Choose two.)

A) Combine the inputs from the DB2 Enterprise stage and two Oracle Enterprise stages using the Sort options of the Funnel stage defined onthe key columns.
B) Use a separate Oracle Enterprise stage for each source table to a Funnel stage and then perform an inner join with rows from a DB2 Enterprise stage.
C) Using a master DB2 Enterprise stage, merge by dropping unmatched masters against a single Oracle Enterprise stage with custom SQL with UNION ALL.
D) Use a Lookup stage to combine the DB2 Enterprise input with each Oracle Enterprise reference link using range partitioning to limit each reference by historical data values.

2. You changed the logic in an existing parallel shared container within your project. This shared container is used by other parallel jobs within your project. Which two actions are rue regarding this change to the parallel shared container? (Choose two.)

A) You can create a sequencer to re-compile all of the routines using this shared container.
B) Jobs using this shared container can be identified using advanced find.
C) Jobs using this parallel shared container need to be re-compiled.
D) You can compile the shared container and all jobs using it will have the changes available.

3. Which three statements are true about National Language Support (NLS)? (Choose three.)

A) Reading or writing 7-bit ASCII data from a database does not require NLS support.
B) Reading data from an UTF-16 database requires a DataStage installation with NLS enabled.
C) NLS can be added to an existing DataStage Server by using the plug-in installer.
D) Within an NLS enabled DataStage environment, maps are used to convert external data into UTF-16.
E) NLS must be selected during installation to use it.

4. Which command line switch can be used to return the most recent start time for a given job?

A) dsjob -lognewest <Project> <Job>
B) dsjob -run TIME <Project> <Job>
C) dsjob -jobinfo <Project> <Job>
D) dsjob -projectinfo <Project> -job <Job>

5. Click the Exhibit button.
Based on the dump score fragment provided in the exhibit, which two operators were added by the Parallel Framework during runtime to satisfy the Join stage execution requirements? (Choose two.)

A) Tsort
B) Buffer
C) APT_JoinSubOperatorNC
D) APT_RealFileExportOperator

Solutions: