Informatica pr000041 practice test

PowerCenter Data Integration 9.x:Developer Specialist Exam


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
Answer:

B

Discussions

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
Answer:

A

Discussions

Question 3

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
Answer:

D

Discussions

Question 4

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
Answer:

A

Discussions

Question 5

The word FALSE is a valid Filter transformation condition?

  • A. True
  • B. False
Answer:

B

Discussions

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
Answer:

D

Discussions

Question 7

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
Answer:

B

Discussions

Question 8

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
Answer:

B

Discussions

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
Answer:

A

Discussions

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
Answer:

B,C

Discussions
To page 2