Informatica PR000041 - PowerCenter Data Integration 9.x:Developer Specialist Exam
Page: 3 / 14
Total 70 questions
Question #11 (Topic: )
What function could be used to exchange'i'with'I'in the COMPANY port given the following
expression?
functionname{1, COMPANY, 'i','I')
expression?
functionname{1, COMPANY, 'i','I')
A. CHOOSE
B. REPLACECHR
C. REG_REPLACE
D. INSTR
Answer: B
Question #12 (Topic: )
Which port types are applicable to the Stored Procedure transformation?(Choose all that
apply) Choose 3 answers
apply) Choose 3 answers
A. lnput
B. Output
C. Variable
D. Return
Answer: A,B,D
Question #13 (Topic: )
Which is the correct priority of assigning a mapping variable?
A. Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value
B. Session parameter file, workflow parameter file, repository value, declared initial value
C. Repository value, workflow parameter file, pre-session assignment, session parameter file, default value
D. Repository value, declared initial value, default value
Answer: A
Question #14 (Topic: )
Which command line tool would you use to execute a workflow?
A. infasetup
B. infacmd
C. pmcmd
D. pmrep
Answer: C
Question #15 (Topic: )
What is a pipeline lookup transformation?
A. A lookup created using a pipeline which contains a target
B. A lookup cache split over pipelines of a partitioned mapping
C. A lookup associated with the Source Qualifier or an Application source such as JMS or SAP
D. A pipeline lookup does not exist
Answer: C
