Which stage classifies data rows from a single input into groups and computes totals?
Which stage classifies data rows from a single input into groups and computes totals?
Which two statements are true?
You are setting up a clustered environment. Each node in the cluster has public and private
network adapters. The private network uses fast Ethernet. Which two statements are true? (Select
two)
Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?
Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?
What two options allow you to automatically save row counts and CPU time for each instance of an operator?
You are asked by your customer to collect partition level runtime meta-data for DataStage Parallel
jobs. You must collect this data after each job completes. What two options allow you to
automatically save row counts and CPU time for each instance of an operator? (Select two)
Which derivations are executed last in the Transformer stage?
Which derivations are executed last in the Transformer stage?
Which technique will enable you to retrieve the sum of the last group?
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?
Which behavior is expected?
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?
Which statement is true about table definitions created in DataStage Designer?
Which statement is true about table definitions created in DataStage Designer?
What are two advantages of using Runtime Column Propagation (RCP)?
What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)
which two properties define the record?
In a file defining a partial schema, which two properties define the record? (Choose two.)