Informatica PowerCenter Data Integration 10 Developer
Professional Practice Exam
**Question 1. Which component in the Informatica domain is responsible for
coordinating requests from client tools to the appropriate services?**
A) Repository Service
B) Integration Service
C) Gateway Node
D) Worker Node
Answer: C
Explanation: The Gateway Node receives client requests and routes them to the
Repository or Integration services.
**Question 2. In PowerCenter, which service stores all metadata such as source
definitions, target definitions, and mappings?**
A) Integration Service
B) Repository Service
C) Web Services Hub
D) Monitoring Service
Answer: B
Explanation: The Repository Service manages the repository database where all
design‑time metadata is stored.
**Question 3. Which client tool is used to create and edit mappings?**
A) Workflow Manager
, Informatica PowerCenter Data Integration 10 Developer
Professional Practice Exam
B) Workflow Monitor
C) Designer
D) Repository Manager
Answer: C
Explanation: The Designer provides Source Analyzer, Target Designer, and Mapping
Designer for building mappings.
**Question 4. Which command‑line utility is used to start, stop, or restart
Informatica services?**
A) pmrep
B) pmcmd
C) infacmd.sh
D) dispmgr
Answer: C
Explanation: `infacmd.sh` (or `infacmd.bat`) provides administrative commands for
services, nodes, and the domain.
**Question 5. Which privilege must a user have to be able to create a new folder
in the repository?**
A) Read
B) Write
C) Create Folder
, Informatica PowerCenter Data Integration 10 Developer
Professional Practice Exam
D) Delete
Answer: C
Explanation: The “Create Folder” privilege explicitly allows a user to create
folders; Write alone does not.
**Question 6. When connecting to a relational source, which transformation is
automatically added by the Designer?**
A) Expression
B) Source Qualifier
C) Filter
D) Lookup
Answer: B
Explanation: The Source Qualifier (SQ) is the default transformation that reads
rows from relational sources.
**Question 7. In a Source Qualifier, which property enables the generation of
distinct rows before they are passed downstream?**
A) SQL Override
B) Filter Condition
C) Select Distinct
D) Join Type
Answer: C
, Informatica PowerCenter Data Integration 10 Developer
Professional Practice Exam
Explanation: Setting “Select Distinct” to true adds a DISTINCT clause to the
generated SQL.
**Question 8. Which built‑in function would you use in an Expression
transformation to convert a string to uppercase?**
A) UPPERCASE()
B) TOUPPER()
C) UPPER()
D) CONVERT_UPPER()
Answer: C
Explanation: The `UPPER()` function returns the uppercase version of a string.
**Question 9. In a Filter transformation, what happens to rows that do not meet
the filter condition?**
A) They are sent to a reject output port.
B) They are written to a log file.
C) They are discarded from the pipeline.
D) They cause the session to fail.
Answer: C
Explanation: Filter removes rows that evaluate to FALSE; only rows meeting the
condition continue.
Professional Practice Exam
**Question 1. Which component in the Informatica domain is responsible for
coordinating requests from client tools to the appropriate services?**
A) Repository Service
B) Integration Service
C) Gateway Node
D) Worker Node
Answer: C
Explanation: The Gateway Node receives client requests and routes them to the
Repository or Integration services.
**Question 2. In PowerCenter, which service stores all metadata such as source
definitions, target definitions, and mappings?**
A) Integration Service
B) Repository Service
C) Web Services Hub
D) Monitoring Service
Answer: B
Explanation: The Repository Service manages the repository database where all
design‑time metadata is stored.
**Question 3. Which client tool is used to create and edit mappings?**
A) Workflow Manager
, Informatica PowerCenter Data Integration 10 Developer
Professional Practice Exam
B) Workflow Monitor
C) Designer
D) Repository Manager
Answer: C
Explanation: The Designer provides Source Analyzer, Target Designer, and Mapping
Designer for building mappings.
**Question 4. Which command‑line utility is used to start, stop, or restart
Informatica services?**
A) pmrep
B) pmcmd
C) infacmd.sh
D) dispmgr
Answer: C
Explanation: `infacmd.sh` (or `infacmd.bat`) provides administrative commands for
services, nodes, and the domain.
**Question 5. Which privilege must a user have to be able to create a new folder
in the repository?**
A) Read
B) Write
C) Create Folder
, Informatica PowerCenter Data Integration 10 Developer
Professional Practice Exam
D) Delete
Answer: C
Explanation: The “Create Folder” privilege explicitly allows a user to create
folders; Write alone does not.
**Question 6. When connecting to a relational source, which transformation is
automatically added by the Designer?**
A) Expression
B) Source Qualifier
C) Filter
D) Lookup
Answer: B
Explanation: The Source Qualifier (SQ) is the default transformation that reads
rows from relational sources.
**Question 7. In a Source Qualifier, which property enables the generation of
distinct rows before they are passed downstream?**
A) SQL Override
B) Filter Condition
C) Select Distinct
D) Join Type
Answer: C
, Informatica PowerCenter Data Integration 10 Developer
Professional Practice Exam
Explanation: Setting “Select Distinct” to true adds a DISTINCT clause to the
generated SQL.
**Question 8. Which built‑in function would you use in an Expression
transformation to convert a string to uppercase?**
A) UPPERCASE()
B) TOUPPER()
C) UPPER()
D) CONVERT_UPPER()
Answer: C
Explanation: The `UPPER()` function returns the uppercase version of a string.
**Question 9. In a Filter transformation, what happens to rows that do not meet
the filter condition?**
A) They are sent to a reject output port.
B) They are written to a log file.
C) They are discarded from the pipeline.
D) They cause the session to fail.
Answer: C
Explanation: Filter removes rows that evaluate to FALSE; only rows meeting the
condition continue.
