IBM Assessment InfoSphere DataStage v9.1

1.

Which stage classifies data rows from a single input into groups and computes totals?

Modify stage Compare stage Aggregator stage Transformer stage

2.

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

Adds a new row to the fact table. Adds a new row to a dimension table. Overwrites an attribute in the fact table. Overwrites an attribute in a dimension table.

3.

Which derivations are executed last in the Transformer stage?

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

4.

You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which technique will enable you to retrieve the sum of the last group?

Output the sum that you generated each time you process a row for which the LastRow() function returns

True. Output the sum that you generated up to the previous row each time you process a row with a "1" in theFlag column. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage.Take the MAX of the QTY columnfor each group. Output the sum that you generated up to the previous row each time you process a row with a "1" in theFlag column. Use the FirstRow()function to determine when the group is done.

5.

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Assume the legacy NULL processing option is turned off. Which behavior is expected?

The job aborts. NULL is written to the target stage variable. The input row is either dropped or rejected depending on whether the Transformer has a reject link. The target stage variable is populated with spaces or zeros depending on the stage variable data type.

6.

Which statement is true about table definitions created in DataStage Designer?

By default, table definitions created in DataStage Designer are visible to other Information Server products. Table definitions created in DataStage Designer are local to DataStage and cannot be shared with otherInformation Server products. When a table definition is created in one DataStage project, it is automatically available in other DataStageprojects, but not outside ofDataStage. Table definitions created in DataStage Designer are not by default available to other Information Serverproducts, but they can be shared withother Information Server products.

7.

What role must a user have to delete shared metadata assets from the repository?

DataStage Administrator Business Glossary Administrator Common Metadata Administrator Information Analyzer Administrator

8.

How does the Complex Flat File stage (CFF) support the use of OCCURS clauses within COBOL files?

Each element of the OCCURS clause is treated as a subrecord. The CFF stage cannot process COBOL files with OCCURS clauses. Each element of the OCCURS clause is treated as a column of raw data. Each element of the OCCURS clause is treated as a separate element in an array.

9.

Which statement is true about creating DataStage projects?

DataStage projects cannot be created during DataStage installation. After installation only DataStage developers can create DataStage projects. After installation DataStage projects can be created in DataStage Administrator. After installation DataStage projects can be created in the Information Server Web Console.

10.

You are editing the configuration file. Which statement is true about file system efficiency?

Using multiple scratch spaces in a logical node improves performance. For the resource disk, it is best to use the partition where the engine is installed. Creating scratch disk spaces on an internal disk rather than on an NFS drive improves sort performance. In a clustered environment where NAS is used for a common storage, you must specify the internal disk forscratch disk.

IBM Assessment InfoSphere DataStage v9.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

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