IBM Assessment InfoSphere DataStage v9.1 Set 1

1.

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

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

2.

A customer must compare a date column with a job parameter date to determine which output links the row belongs on. What stage should be used for this requirement?

Filter stage Switch stage Compare stage Transformer stage

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?

Create a stage variable named sv_IsNewProduct and follow it by a second stage variable named sv_Product. Map the Input.Product column tosv_Product. The derivation for sv_IsNewProduct is: IF

Input.Product = sv_Product THEN "YES" ELSE "NO". Create a stage variable named sv_IsNewProduct and follow it by a second stage variable namedsv_Product. Map the Input.Product column tosv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES" ELSE "NO". Create a stage variable named sv_Product and follow it by a second stage variable namedsv_IsNewProduct. Map the Input.Product column tosv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES" ELSE "NO". Create a stage variable named sv_Product and follow it by a second stage variable namedsv_IsNewProduct. Map the Input.Product column tosv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES" ELSE "NO".

4.

Which statement describes what happens when Runtime Column Propagation is disabled for a parallel job?

An input column value flows into a target column only if it matches it by name. An input column value flows into a target column only if it is explicitly mapped to it. You must set APT_AUTO_MAP project environment to true to allow output link mapping to occur. An input column value flows into a target column based on its position in the input row. For example, firstcolumn in the input row goes into thefirst target column.

5.

Which statement is true when using the SaveInputRecord() function in a Transformer stage.

You can only use the SaveInputRecord() function in Loop variable derivations. You can access the saved queue records using Vector referencing in Stage variable derivations. You must retrieve all saved queue records using the GetSavedInputRecord() function within Loop variablederivations. You must retrieve all saved queue records using the GetSavedInputRecord() function within Stage variablederivations.

6.

Which derivations are executed first in the Transformer stage?

Input column derivations Loop variable derivations Stage variable derivations Output column derivations

7.

What is the purpose of the APT_DUMP_SCORE environment variable?

There is no such environment variable. It is an environment variable that turns on the job monitor. It is an environment variable that enables the collection of runtime performance statistics. It is a reporting environment variable that adds additional runtime information in the job log.

8.

Suppose a user ID has been created with DataStage and QualityStage component authorization. Which client application would be used to give that user ID DataStage Developer permission?

DataStage Director client DataStage Designer client DataStage Administrator client Information Server Web Console Administrator client

9.

Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

Change the partitioning to hash. Sort the data on the reference link. Change the lookup option in the stage properties to "Sparse". Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

10.

Which requirement must be met to read from a database in parallel using the ODBC connector?

ODBC connector always reads in parallel. Set the Enable partitioning property to Yes. Configure environment variable $APT_PARTITION_COUNT. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

IBM Assessment InfoSphere DataStage v9.1 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Assessment InfoSphere DataStage v9.1 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner