PR000041 Exam Questions and Answers

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression?
functionname{1, COMPANY, 'i' , 'I')

Answer(s): B

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

Answer(s): A,B,D

Which is the correct priority of assigning a mapping variable?

Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value
Session parameter file, workflow parameter file, repository value, declared initial value
Repository value, workflow parameter file, pre-session assignment, session parameter file, default value
Repository value, declared initial value, default value

Answer(s): A

Which command line tool would you use to execute a workflow?

Answer(s): C

What is a pipeline lookup transformation?

A lookup created using a pipeline which contains a target
A lookup cache split over pipelines of a partitioned mapping
A lookup associated with the Source Qualifier or an Application source such as JMS or SAP
A pipeline lookup does not exist

Answer(s): C

Informatica PR000041 Exam (page: 3) Informatica PowerCenter Data Integration 9.x:Developer Specialist Updated on: 12-Jan-2026