Which type of Join would you select for the Join Stage to output unmatched records from both input data sources?

• A. Left outer join
• B. Right outer join
• C. Full outer join
• D. Inner join

Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?

• A. If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together
• B. If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results
• C. ROUND ROBIN ensures correct results
• D. If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together

For the Information Server Repository, which Relational Database Management System (RDMS) CANNOT be used?

• A. Microsoft SQL Server
• B. Oracle
• C. Informix
• D. DB2 UDB

Under which scenario may a user benefit from using InfoSphere Discovery?

• A. Automate data relationship discovery
• B. Automate transformation rule discovery
• C. Prototype a data model for the first time
• D. Automate business object identification
• E. All of the above

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 the LastRow() function returns True.
• B. 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.
• C. 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.
• D. 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.
• 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.