I. Architecture (Approx.

20 minutes)

1. Which of the following components is responsible for executing the mapping logic
and extracting, transforming, and loading data? a) Repository Service b) Integration
Service c) Domain Configuration Database d) Metadata Manager Service

b) Integration Service

2. The Informatica Domain is a: a) Single server installation of all Informatica services.

b) Logical grouping of services managed by a master gateway node. c) Physical
server dedicated to hosting the Repository Service. d) Collection of repositories used
for different projects.-- b) Logical grouping of services managed by a master gateway
node.
3. What is the primary function of the Repository Service? a) Executing data integration
workflows. b) Managing and storing metadata about Informatica objects. c)
Monitoring the performance of Informatica jobs. d) Providing a user interface for
development tasks. -- b) Managing and storing metadata about Informatica objects.
4. The PowerCenter Client tools communicate with the Informatica server primarily
through the: a) Repository Database. b) Integration Service. c) Repository Service. d)
Domain Configuration Database.
5. Which of the following is NOT a key component of the Informatica PowerCenter
architecture? a) Repository Manager b) Integration Service c) Data Masking Service
d) Repository Service
6. The purpose of the Domain Configuration Database is to store: a) Metadata about
mappings, workflows, and sessions. b) Runtime statistics and logs of workflow
executions. c) Configuration information for the Informatica Domain and its
services. d) Source and target connection details.
7. In a high-availability configuration, which component ensures continuous operation in
case of a primary node failure? a) Load Balancer b) Backup Repository c) Secondary
Integration Service d) Master Gateway Node
8. Which service is responsible for managing user authentication and authorization
within the Informatica Domain? a) Integration Service b) Repository Service c)
Administrator Console d) Authentication Service (part of the Domain)
9. The PowerCenter Integration Service reads source data and writes to target systems
using: a) Connectors. b) Mappings. c) Workflows. d) Sessions.
10. What is the role of the Metadata Manager (if present in the environment)? a) To
execute data integration workflows. b) To manage and govern metadata across
various systems, including Informatica. c) To monitor the performance of
Informatica services. d) To provide version control for Informatica objects.

II. Repository & Workflow Manager (Approx. 30 minutes)

1. Which object in the Repository Manager allows you to define the flow of tasks and
the order in which they are executed? a) Mapping b) Session c) Workflow d) Worklet
2. What is the purpose of deploying a folder in Informatica? a) To move objects between
different repositories. b) To create a backup of repository objects. c) To move objects
between different environments (e.g., Dev, Test, Prod). d) To share objects
between different developers simultaneously.
3. Which of the following is NOT a valid type of task in a Workflow? a) Session Task b)
Email Task c) Mapping Task d) Command Task
 4. What is the significance of a reusable transformation? a) It can only be used once
within a mapping. b) It can be used in multiple mappings within the same or
different folders. c) Changes made to it only affect the current mapping. d) It is
automatically optimized for better performance.
5. Which of the following actions CANNOT be performed directly on a deployed
workflow? a) Running the workflow. b) Viewing the workflow log. c) Editing the
workflow properties. d) Aborting the workflow.
6. What is the purpose of a worklet? a) To define source and target connections. b) To
group a set of tasks that can be reused in multiple workflows. c) To define the
transformation logic for data. d) To monitor the execution status of workflows.
7. Which of the following is used to define the connection information for source and
target databases within a session? a) Mapping Parameters b) Workflow Variables c)
Connection Objects d) Source Qualifiers
8. What happens when you check in an object in the Repository Manager? a) It becomes
available for execution by the Integration Service. b) It is marked as a stable
version and stored in the repository database. c) It is automatically deployed to the
production environment. d) It is locked for editing by other developers.
9. What is the purpose of version control in the Informatica Repository? a) To improve
the performance of mappings and workflows. b) To track changes made to
repository objects over time and allow for rollback. c) To manage user permissions
and access control. d) To automate the deployment of repository objects.
10. Which of the following is NOT a valid locking mode for a repository object? a)
Exclusive Lock b) Shared Lock c) Read Lock d) Write Lock

III. Monitor (Approx. 20 minutes)

1. Which tool is primarily used to view the status and logs of running and completed
workflows and sessions? a) Repository Manager b) Workflow Manager c) Monitor d)
Administrator Console
2. What information can you typically find in a session log? a) Mapping definitions and
transformation logic. b) Workflow task dependencies and execution order. c) Source
and target connection details. d) Information about data flow, transformations
applied, and error details.
3. What does the "Succeeded" status of a session indicate? a) The session started
successfully. b) All transformations within the mapping executed without errors
and data was loaded to the target. c) The Integration Service successfully connected
to the repository. d) The workflow containing the session completed successfully.
4. If a session fails, where would you typically look first to understand the reason for the
failure? a) Workflow Log b) Session Log c) Repository Manager Audit Log d)
Administrator Console Log
5. What does the "Running" status of a workflow indicate? a) All sessions within the
workflow have completed successfully. b) At least one task within the workflow is
currently being executed. c) The Integration Service is connected to the repository.
d) The workflow definition is being edited in the Workflow Manager.
6. Which of the following is NOT a typical status you would see for a task in the
Monitor? a) Succeeded b) Failed c) Running d) Pending Deployment
7. What type of information can you typically find in a workflow log? a) Details about
individual row transformations. b) Summary of session executions and any errors
encountered at the workflow level. c) Source and target database schemas. d)
Mapping parameter and variable values.
 8. How can you filter the information displayed in the Monitor? a) By editing the
workflow definition. b) By applying filters based on status, time, workflow name,
etc. c) By modifying the Integration Service configuration. d) By changing the
repository database settings.
9. What does the "Terminated" status of a workflow or session usually indicate? a) It
completed successfully after a long runtime. b) It was manually stopped by a user
or due to a critical error. c) It is waiting for a resource to become available. d) It has
been scheduled for a future run.
10. Which of the following is NOT a function typically available in the Informatica
Monitor? a) Viewing task details and logs. b) Starting and stopping workflows and
sessions. c) Editing mapping transformations. d) Viewing performance statistics of
sessions.

IV. Basic and Advanced Transformations (Approx. 50 minutes)

1. Which transformation is used to filter rows based on a specified condition? a)

Aggregator b) Joiner c) Filter d) Router
2. Which transformation is used to combine data from multiple sources based on a
related column? a) Expression b) Lookup c) Sorter d) Joiner
3. Which transformation allows you to perform calculations on input columns and create
new output columns? a) Filter b) Expression c) Aggregator d) Lookup
4. Which transformation is used to retrieve data from a source based on a lookup
condition? a) Rank b) Normalizer c) Lookup d) Update Strategy
5. Which transformation is used to calculate aggregate values like sum, average, count,
etc.? a) Router b) Aggregator c) Sorter d) Expression
6. Which transformation is used to split a single input stream into multiple output
streams based on specified conditions? a) Joiner b) Filter c) Router d) Sequence
Generator
7. Which transformation is used to sort data based on one or more columns? a) Rank b)
Sorter c) Aggregator d) Expression
8. Which transformation is used to generate sequential numbers? a) Normalizer b)
Sequence Generator c) Expression d) Update Strategy
9. Which transformation is used to handle slowly changing dimensions (SCDs)? a)
Joiner b) Lookup c) Update Strategy d) Filter
10. What is the primary difference between a connected and an unconnected Lookup
transformation? a) Connected Lookups can only retrieve one row, while unconnected
Lookups can retrieve multiple rows. b) Connected Lookups receive input directly
from the data flow, while unconnected Lookups are called using a function in
another transformation. c) Connected Lookups can only be used with relational
sources, while unconnected Lookups can be used with flat files. d) There is no
significant difference between them.
11. Which of the following is an example of an active transformation? a) Expression b)
Filter c) Lookup (when configured to return multiple rows for a single input) d)
Sorter
12. Which of the following is an example of a passive transformation? a) Aggregator b)
Router c) Expression d) Joiner (in some configurations)
13. What is the purpose of the Normalizer transformation? a) To calculate aggregate
values. b) To split a single input row into multiple output rows. c) To join data
from multiple sources. d) To filter out unwanted data.
 14. Which transformation can be used to assign a rank to rows based on a specified
column? a) Sorter b) Aggregator c) Rank d) Expression
15. What is the purpose of the Transaction Control transformation? a) To control the
order of data processing. b) To define transaction boundaries for committing or
rolling back target data. c) To transform data based on transaction volume. d) To
generate transaction IDs.
16. In a Joiner transformation, what happens to unmatched rows when using an "Inner
Join"? a) They are included in the output with null values for the missing columns. b)
They are written to a reject port. c) They are discarded and not included in the
output. d) They cause the session to fail.
17. What is the purpose of the XML Source Qualifier transformation? a) To transform
XML data into a relational format. b) To read data from XML files and parse it
into columns. c) To write data to XML files. d) To validate the structure of XML
files.
18. Which transformation can be used to implement complex business logic that cannot
be achieved with standard transformations? a) Expression b) Lookup c) Java
Transformation d) Filter
19. What is the difference between a Source Qualifier filter and a Filter transformation?
a) Source Qualifier filter is applied after the data is read into the pipeline, while the
Filter transformation is applied at the source database level. b) Source Qualifier
filter is applied at the source database level, potentially improving performance
by reducing the amount of data read, while the Filter transformation is applied
within the Informatica pipeline. c) Source Qualifier filter can only use simple
conditions, while the Filter transformation allows for complex expressions. d) There
is no significant difference between them.
20. When using an Update Strategy transformation, which flag is typically used to mark a
row for insertion into the target table? a) DD_UPDATE b) DD_INSERT c)
DD_DELETE d) DD_REJECT

V. Parameters & Variables (Approx. 30 minutes)

1. What is the main purpose of using parameters in Informatica? a) To store temporary

values during workflow execution. b) To define values that can change between
different executions of a workflow or session. c) To perform calculations within
transformations. d) To define connections to source and target systems.
2. What is the difference between a workflow parameter and a session parameter? a)
Workflow parameters can be used in sessions, while session parameters cannot be
used in workflows. b) Workflow parameters are defined at the workflow level and
can be accessed by all sessions within that workflow, while session parameters
are specific to a particular session. c) Workflow parameters are defined in the
mapping, while session parameters are defined in the workflow. d) There is no
functional difference between them.
3. What is the purpose of using variables in Informatica? a) To define constant values
that do not change during workflow execution. b) To store and update values
during the execution of a workflow or session. c) To define connection details for
databases. d) To specify filtering conditions for data.
4. At which level can you define workflow variables? a) Mapping level b) Session level
c) Workflow level d) Transformation level
5. What is the difference between a parameter file and a variable file? a) Parameter files
store values for parameters, while variable files store values for variables. b)
 Parameter files are used to initialize parameters at the start of a workflow or
session, while variable files are used to persist the last value of variables across
different runs. c) Parameter files are mandatory, while variable files are optional. d)
There is no functional difference between them.
6. Which of the following is NOT a valid scope for a variable in Informatica? a)
Mapping b) Session c) Workflow d) Integration Service
7. How do you reference a parameter within a mapping or workflow task? a) Using a
dollar sign ($) followed by the parameter name (e.g., $$ParameterName). b)
Using a hash symbol (#) followed by the parameter name (e.g., ##ParameterName). c)
Directly using the parameter name. d) Using curly braces {} around the parameter
name (e.g., {ParameterName}).
8. What is the purpose of the "Save state for each run" option for a workflow variable?
a) To save the initial value of the variable for the next run. b) To save the last
assigned value of the variable at the end of the current run, so it can be used as
the initial value for the next run. c) To save all the intermediate values of the
variable during the workflow execution. d) To prevent the variable's value from being
updated during the workflow execution.
9. Which of the following system variables holds the current date and time of the
Integration Service? a) $$SYSDATE b) $$DATETIME c) SYSDATE d)
$PMSYSDATETIME
10. How can you override the value of a workflow or session parameter at runtime? a) By
editing the mapping definition. b) By modifying the Integration Service configuration.
c) By providing a parameter file when starting the workflow or session. d) By
changing the repository database settings.

VI. Inbuilt Functions (Approx. 30 minutes)

1. Which function is used to concatenate two or more strings? a) SUBSTR b) LENGTH

c) CONCAT d) TRIM
2. Which function is used to extract a substring from a string? a) CONCAT b) LENGTH
c) SUBSTR d) REPLACE
3. Which function returns the length of a string? a) SUBSTR b) LENGTH c) INSTR d)
LTRIM
4. Which function is used to find the position of a substring within a string? a) SUBSTR
b) LENGTH c) INSTR d) RTRIM
5. Which function is used to convert a string to uppercase? a) LOWER b) INITCAP c)
UPPER d) TO_CHAR
6. Which function is used to convert a string to lowercase? a) UPPER b) INITCAP c)
LOWER d) TO_CHAR
7. Which function is used to convert a date to a string with a specified format? a)
TO_DATE b) TO_NUMBER c) TO_CHAR d) DECODE