Free PR000041 – PowerCenter Data Integration 9.x:Developer Specialist Practice Test Question

Select all that apply, then click Submit answer.

• ○

  From an expression

• ○

  As a Post-Session SQL command

• ○

  As a Pre-Session SQL command

• ○

  As the only object In the mapping
  

Select all that apply, then click Submit answer.

• ○

  A transformation is active if It rearranges the order of the rows in the pipeline

• ○

  A transformation is active if it does not change the number of rows in the pipeline

• ○

  Transformations can be active and passive at the same time

• ○

  A passive transformation will not change the number of rows in the pipeline
  

Select all that apply, then click Submit answer.

• ○

  Option A

• ○

  Option B

• ○

  Option C

• ○

  Option D
  

Select all that apply, then click Submit answer.

• ○

  Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST

• ○

  Describes an INNER JOIN between PRODUCT AND PRODUCT_COST

• ○

  Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST

• ○

  Can be created within Informatica PowerCenter
  

Select all that apply, then click Submit answer.

• ○

  lnput

• ○

  Output

• ○

  Variable

• ○

  Return
  

Select an option, then click Submit answer.

• ○

  Decision

• ○

  Assignment

• ○

  Control

• ○

  Command
  

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
  

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
  

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
  

Select an option, then click Submit answer.

• ○

  A mapplet can contain a target definition

• ○

  A mapplet can contain a source definition as well as a source qualifier

• ○

  Every mapplet must have at least 1 Input transformation as well as 1 Output transformation

• ○

  A mapplet can contain a Normalizer transformation