← Back to exam page

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

Free demo downloads

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Given the picture shown below:

C:\Users\albo\Desktop\1.jpg

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

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
Question 5

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

Select all that apply, then click Submit answer.

  • ○

    lnput
  • ○

    Output
  • ○

    Variable
  • ○

    Return
Question 6

Which of the following is a reusable task available in workflow manager?

Select an option, then click Submit answer.

  • ○

    Decision

  • ○

    Assignment

  • ○

    Control

  • ○

    Command