Informatica PR000041 Online Practice Questions and Exam Preparation

Informatica PR000041 Online Questions & Answers

• Question 21:

  When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)

  A. Filter, Joiner, Rank
  B. Union, Filter, Aggregator
  C. Rank, Lookup, Aggregator
  D. Joiner, Rank, Sorter
  D. Joiner, Rank, Sorter

• Question 22:

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

  A. A transformation is active if It rearranges the order of the rows in the pipeline
  B. A transformation is active if it does not change the number of rows in the pipeline
  C. Transformations can be active and passive at the same time
  D. A passive transformation will not change the number of rows in the pipeline
  A. A transformation is active if It rearranges the order of the rows in the pipeline
  D. A passive transformation will not change the number of rows in the pipeline

• Question 23:

  Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

  A. 5 fields are in the index cache and 3 are in the data cache
  B. 3 fields are in the index cache and 2 fields are in the data cache
  C. 2 fields are in the index cache and 3 fields are in the data cache
  D. 2 fields are in the index and 5 fields are in the data cache
  A. 5 fields are in the index cache and 3 are in the data cache

• Question 24:

  Which of the following PowerCenter applications is browser-based in the Informatica 9.x environment?

  A. Repository Manager
  B. Informatica Administrator
  C. Workflow Monitor
  D. Workflow Manager
  B. Informatica Administrator

• Question 25:

  Which of the following techniques could be used to filter data read from a flat file source?

  A. Create a valid condition in the Filter attribute of the flat file's Source Qualifier
  B. Place a Filter transformation directly after the flat file's Source Qualifier
  C. An Expression transformation with an output port's expression defined to filter records
  D. An Expression transformation with all of the output port's default values set to blank
  B. Place a Filter transformation directly after the flat file's Source Qualifier

• Question 26:

  What does the function SETVARIABLE ($$Variable, value) do?

  A. Assign the minimum value of the two to $$Variable
  B. Assign the maximum value of the two to $$Variable
  C. Allows the assignment of a value to a parameter
  D. Assign the value to $$Variable, unless the value is null
  D. Assign the value to $$Variable, unless the value is null

• Question 27:

  By default workflows always have a run status of succeeded. Identify the methods to change the run status of the workflow. For the puposes of this question, assume there are no worklets in the workflow.

  A. Check the Fail Parent if this task fails option box on the session task
  B. Use a Control Task with a Control Option setting of Fail Me
  C. Use an assignment task to call the ERROR() function
  D. Use a command task to set the value of $RC to a negative number
  C. Use an assignment task to call the ERROR() function

• Question 28:

  Which statement is correct regarding User-Defined Functions (UDF)?

  A. A UDF name can contain letters, numbers and underscores
  B. Can be used in mappings and transformations however not in mapplets
  C. Can be reused from a shared folder as shortcut
  D. Can contain Java code snippets
  A. A UDF name can contain letters, numbers and underscores

• Question 29:

  A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)

  A. Read permissions on the two folders
  B. Read permissions on the two folders as well as have both folders opened
  C. Full access (Read, Write and Execute permissions) on both folders
  D. Mappings cannot be compared across folders using PowerCenter Designer
  B. Read permissions on the two folders as well as have both folders opened

• Question 30:

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

  A. Expression, Router, Joiner
  B. Update Strategy, Expression, Aggregator
  C. Stored Procedure, Joiner, Router
  D. Router, Update Strategy, Joiner
  D. Router, Update Strategy, Joiner