Try IBM : A2090-303 practice torrent pass for sure

IBM A2090-303 Exam Syllabus Topics:

IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment Sample Questions:

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

2. What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

A) Manually break the file into multiple files by record type.
B) Define record definitions on the Constraints tab of the Complex Flat File stage.
C) Load a table definition for each record type on the Records tab of the Complex Flat File stage.
D) Flatten the record types into a single record type.

3. Which statement is correct about the Data Rules stage?

A) If you have Rule Creator role in InfoSphere Information Analyzer, you can create and publish rule definitions and rule set definitions directly from the stage itself.
B) When a job that uses the Data Rules stage runs, the output of the stage is passed to the downstream stages and results are stored in the Analysis Results database (IADB).
C) The Data Rules stage works with rule definitions only; not executable rules.
D) As a best practice, you should create and publish new rules from the Data Rules stage.

4. 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) The job aborts.
C) The value written to the stage variable is undetermined.
D) NULL is written to the stage variable.

5. When using the Column Export stage, what are two export column type property values allowed for the combined single output column result? (Choose two.)

A) Binary
B) Decimal
C) Integer
D) VarChar
E) Vector

Solutions: