InfoSphere DataStage v8.5 Certification Dump

InfoSphere DataStage v8.5 Certification Examination Dump
Exam Name: InfoSphere DataStage v8.5                                               Exam Type: IBM
Exam Code: 000-421                                                                     Total Questions: 129

Page 1 of 46 : Sample Certification Dump

QUESTION NO: 1
The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2).
Suppose that input_column1 contains a NULL value. Which behavior is expected?
A. The job aborts.
B. NULL is written to the target stage variable.
C. The input row is either dropped or rejected depending on whether the Transformer has a reject link.
D. The target stage variable is populated with spaces or zeros depending on the stage variable
data type.
Answer: B


QUESTION NO: 2
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 three techniques will enable you to retrieve the sum of the last group? (Choose three.)
A. Output the sum that you generated each time you process a row for which theLastRow()
function returns True.
B. Output the sum that you generated up to the previous row each time youprocess a row with a "1" in the Flag column.
C. Within each group sort the Flag column in ascending order. Output the sum each time you
process the row with a "1" in the Flag column.
D. Output a running total for each group for each row. Follow the Transformer stage by an
Aggregator stage. Take the MAX of the QTY column for each group.
E. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the LastRow() function to determine when the last group is done.
Answer: C,D,E


QUESTION NO: 3
Records in a source file must be copied to multiple output streams for further processing. Which
two conditions would require the use of a Transformer stage instead of a Copy stage? (Choose
two.)
A. Renaming one or more output columns.
B. Concatenating data from multiple input columns.
C. Converting some input columns from integers to strings.
D. Directing selected output records down one output link rather than another.
Answer: B,D


QUESTION NO: 4
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. Filter stage
B. Switch stage
C. Transformer stage
D. Split Vector stage
Answer: A


QUESTION NO: 5
Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)
A. Look up whether a record with a matching business key value exists in a dimension table. If it
does, add new values for selected fields to values lists for those fields.
B. Look up whether a record with a matching business key value exists in a fact table. If it does
not, retrieve a new surrogate key value and insert a new row into the fact table.
C. Look up whether a record with a matching business key value exists in a dimension table. If it
does not, retrieve a new surrogate key value and insert a new row into the dimension table.
D. Look up whether a record with a matching business key value exists in a dimension table. If it
does, mark the record as not-current, and generate a new record with new values for selected
fields.

Answer: C,D

*** Click Here to Read More Question and Answers... Which will help you to clear examinations.. ***