Informatica PowerCenter Data Integration 9.x:Developer Specialist - PR000041 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Referring to the Sequence Generator transformation, which statement is correct and true?

A. The NextVal column produces the next number in the sequence B. The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence C. The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647 D. The Sequence Generator contains a single input port that represents the initial starting point of the sequence

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which of the following is true about database connections?

A. Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS B. Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories C. MRS connections may be created in either the Workflow Manager or the Administrator D. PowerCenter connections may be created In either the Administrator or the Workflow Manager

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

A. XML target B. MS target C. Relational target D. Dynamic MQ Series target

Discussion 0

Correct Answer: B Vote an answer

Question 4

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

A. Value of the PREVI0US_STATE port is based upon its declared default value B. 'CA' C. NULL D. STATE

Discussion 0

Correct Answer: B Vote an answer

Question 5

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

A. Both Pipelines should be cached for performance reasons B. Pipeline B C. Pipeline B if and only if Pipeline A is sorted D. Pipeline A

Discussion 0

Correct Answer: D Vote an answer

Question 6

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. 2 fields are in the index and 5 fields are in the data cache C. 2 fields are in the index cache and 3 fields are in the data cache D. 3 fields are in the index cache and 2 fields are in the data cache

Discussion 0

Correct Answer: A Vote an answer

Question 7

Which of the following is not a Transaction Control Variable?

A. TC_CONTINUE_TRANSCTION B. TC_ROLLBACK_BEFORE C. TC_COMMIT_TRANSACTION D. TC COMMIT AFTER

Discussion 0

Correct Answer: C Vote an answer