We're so confident of our products that we provide no hassle product exchange.
IBM Assessment: InfoSphere DataStage v8.5 Sample Questions:
1. A job needs to split a single Data Set into three Data Sets based on conditions that are supplied at runtime. Which stage would allow you to parameterize the conditions for splitting the input data set?
A) Switch stage
B) Transformer stage
C) Filter stage
D) Split Vector stage
2. When creating a Wrapper stage, which three tasks need to be done? (Select three)
A) Specify the command to be executed by the Wrapper.
B) Create Table Definitions that define the Wrapper's input and output columns.
C) Specify whether input rows are to be processed automatically or manually.
D) Code and compile the C/C++ Wrapper source code.
E) Specify how Wrapper property values are to be converted.
3. Which three environment variables are used for reporting on DataStage jobs? (Select three)
A) $OSH_PRINT_SCHEMAS
B) $APT_DUMP_SCORE
C) $APT_PM_STARTUP_CONCURRENCY
D) $APT_DISABLE_ROOT_FORKJOIN
E) $APT_PM_PLAYER_MEMORY
4. You would like to run a particular processing job within a job sequence for each weekday of the week. How could you do this? (Select two)
A) Set the frequency property in the job scheduler to weekdays only.
B) Call a routine in the job sequencer that starts the processing job for each day you would like to process.
C) Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.
D) Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.
5. How is Runtime Column Propagation (RCP) enabled for use in DataStage Jobs?
A) Set the APT_ENABLE_RCP environment variable to TRUE.
B) RCP is by default available for all DataStage Projects.
C) Use RCP definition wizard to initialize RCP for project use.
D) Use the Info Server web console to enable RCP
E) Use the DataStage Administrator to enable RCP for the project.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A,B,E | Question # 3 Answer: A,B,E | Question # 4 Answer: A,C | Question # 5 Answer: E |
By Leif
