Informatica Developer Specialist PR000041 Questions & Answers

• Question 1:

  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

  Correct Answer: B

• Question 2:

  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

  Correct Answer: A

• Question 3:

  What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

  A. ROUND

  B. TRUNC

  C. INSTR

  D. CONCAT

  Correct Answer: A

• Question 4:

  In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

  A. Character day of week, character day of month, and character day of year respectively

  B. Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively

  C. Each produces numerical day of week

  D. Numerical day of week, day of month, and day of year respectively

  Correct Answer: D

• Question 5:

  The word FALSE is a valid Filter transformation condition?

  A. True

  B. False

  Correct Answer: B

• Question 6:

  Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

  A. If a transformation's Active property is cleared or not enabled, the transformation becomes passive

  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

  Correct Answer: D

• Question 7:

  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

  Correct Answer: B

• Question 8:

  A Router transformation has the following group filter conditions:

  Group A: InputValue = 2

  Group B: InputValue > 1

  Default group

  The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

  A. If InputValue = 2, the output will be routed to Group A only

  B. If InputValue = 2, the output will be routed to both groups A and B

  C. If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

  D. Any positive number values other than 1 or 2 will be routed to the Default group

  Correct Answer: B

• Question 9:

  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

  Correct Answer: A

• Question 10:

  Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:

  

  Identify all of the true and correct statements listed below. Choose 2 answers

  A. This picture depicts a join that will be processed within the Informatica PowerCenter engine

  B. This picture depicts a join that will be processed in a database

  C. This picture depicts a SQL UNION operation

  D. This picture depicts an Informatica Homogeneous Join

  Correct Answer: BC