Free PR000041 Exam Braindumps (page: 6)

Page 5 of 18

In which of the following selections are all of the transformations active?

  1. Expression, Router, Joiner
  2. Update Strategy, Expression, Aggregator
  3. Stored Procedure, Joiner, Router
  4. Router, Update Strategy, Joiner

Answer(s): D



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

  1. An unconnected lookup can return multiple rows while a connected lookup may return only one
  2. Both connected and unconnected lookups can return multiple rows
  3. An unconnected lookup may return only one value while a connected lookup may return multiple rows
  4. Both connected and unconnected lookups can return only one row

Answer(s): C



Given the picture shown below:

Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question.
The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST :
Choose 2 answers

  1. Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST
  2. Describes an INNER JOIN between PRODUCT AND PRODUCT_COST
  3. Describes a secondary data flow needed for a sub-select process between PRODUCT AND
    PRODUCT_COST
  4. Can be created within Informatica PowerCenter

Answer(s): B,D



Which of the following statements is correct on workflow events?

  1. A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping
  2. A user-defined event can be created a-d raised in one workflow and then used In another
  3. A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.
  4. A user-defined event can be created in either the Event Wait or Event Raise task

Answer(s): C






Post your Comments and Discuss Informatica PR000041 exam with other Community members:

PR000041 Discussions & Posts