PR000041 by Informatica Actual Free Exam Questions And Answers

Question 1

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. Union, Filter, Aggregator

B. Filter, Joiner, Rank

C. Joiner, Rank, Sorter

D. Rank, Lookup, Aggregator

Discussion 0

Correct Answer: C Vote an answer

Question 2

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

A. Workflow Manager

B. Repository Manager

C. Informatica Administrator

D. Workflow Monitor

Discussion 0

Correct Answer: C Vote an answer

Question 3

When would a Lookup transformation be classified as active?

A. When the setting for lookup policy on multiple match is Use Any Value

B. A lookup cannot be an active transformation

C. A lookup is always active

D. When the lookup is configured to return multiple rows

Discussion 0

Correct Answer: D Vote an answer

Question 4

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

A. Hash auto-keys

B. Based on the transformation scope

C. Pass-through

D. Not a valid partition points

Discussion 0

Correct Answer: A Vote an answer

Question 5

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. Full access (Read, Write and Execute permissions) on both folders

C. Mappings cannot be compared across folders using PowerCenter Designer

D. Read permissions on the two folders as well as have both folders opened

Discussion 0

Correct Answer: D Vote an answer

Question 6

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

A. An Expression transformation with all of the output port's default values set to blank

B. Create a valid condition in the Filter attribute of the flat file's Source Qualifier

C. An Expression transformation with an output port's expression defined to filter records

D. Place a Filter transformation directly after the flat file's Source Qualifier

Discussion 0

Correct Answer: D Vote an answer

Question 7

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

A. Can be used in mappings and transformations however not in mapplets

B. A UDF name can contain letters, numbers and underscores

C. Can contain Java code snippets

D. Can be reused from a shared folder as shortcut

Discussion 0

Correct Answer: B Vote an answer

Informatica PowerCenter Data Integration 9.x:Developer Specialist - PR000041 Exam Practice Test

Contact Us

Useful Links

Latest Updated