← Back to exam page

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

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

An Unconnected Stored Procedure can run in the following fashions?(Choose all that apply) Choose 3 answers

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

Which of the following statments are valid for Active and Passive Transformations? Choose 2 answers

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

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? Choose 2 answers

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

Select all that apply, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D