← Back to exam page

PR000041 – PowerCenter Data Integration 9.x:Developer Specialist

Loading demo links...

Showing 7–9 of 10 questions

Question 7

A Router transformation has the following group filter conditions:

The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

Select an option, then click Submit answer.

  • ○

    If InputValue = 2, the output will be routed to Group A only
  • ○

    If InputValue = 2, the output will be routed to both groups A and B
  • ○

    If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

  • ○

    Any positive number values other than 1 or 2 will be routed to the Default group
Question 8

Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)

Select an option, then click Submit answer.

  • ○

    An unconnected lookup can return multiple rows while a connected lookup may return only one
  • ○

    Both connected and unconnected lookups can return multiple rows
  • ○

    An unconnected lookup may return only one value while a connected lookup may return multiple rows
  • ○

    Both connected and unconnected lookups can return only one row
Question 9

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

Select an option, then click Submit answer.

  • ○

    When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled
  • ○

    When transformation scope is set to a value of transaction, the sorter will sort on every record in the pipeline before it releases any data. The intermediate sort file will have markers for each transaction.
  • ○

    If the distinct check box is not checked, the sorter will produce one record per unique key
  • ○

    The Sorter transformation will utilize database indexes from the source database to perform the sort