Informatica PowerCenter Developer Specialist Certification — Questions and Answers
Question 1: Which default prefix does Designer give an Update Strategy transformation?
- UPS_
- UPD_ (Correct answer)
- UST_
- US_
Correct answer: UPD_
Designer gives Update Strategy transformations the default prefix UPD_.
Question 2: Which workflow property lets several instances of the same workflow run at the same time?
- Enable HA recovery
- Suspend on Error
- Run on Integration Service initialization
- Configure Concurrent Execution (Correct answer)
Correct answer: Configure Concurrent Execution
Configure Concurrent Execution allows several instances of a workflow to run at once, either with the same instance name or with unique instance names.
Question 3: A mapping has an Update Strategy transformation that flags rows as DD_UPDATE. What must 'Treat source rows as' be set to so those flags are used?
- Data driven (Correct answer)
- Insert
- Delete
- Update
Correct answer: Data driven
Only the Data driven setting makes the Integration Service follow the row flags set by Update Strategy transformations.
Question 4: How does the Integration Service get mapping and session metadata when a workflow runs?
- It requests the metadata from the Repository Service (Correct answer)
- It queries the repository database tables directly
- It gets the metadata from the Workflow Manager client
- It reads cached XML exports from disk
Correct answer: It requests the metadata from the Repository Service
The Integration Service connects to the Repository Service, which retrieves and returns metadata from the repository database.
Question 5: Which feature is recommended for grouping specific object versions to promote together from development to test?
- A worklet
- A deployment group (Correct answer)
- A reusable session
- A mapplet
Correct answer: A deployment group
Deployment groups, which can be static or dynamic, collect versioned objects so they can be deployed together.
Question 6: Where do you normally create a relational database connection object for sessions?
- In the Workflow Manager under Connections > Relational (Correct answer)
- In the Repository Manager under Folders
- In the Designer under Sources > Import
- In the Monitor under Integration Service properties
Correct answer: In the Workflow Manager under Connections > Relational
Relational connection objects are created in the Workflow Manager and assigned to sessions.
Question 7: Database partitioning on a relational source is supported for which databases?
- SQL Server and MySQL
- Oracle and IBM DB2 (Correct answer)
- Any ODBC source
- Teradata and Sybase
Correct answer: Oracle and IBM DB2
PowerCenter supports database partitioning for Oracle and IBM DB2 sources.
Question 8: What is the PRIMARY benefit of continuous improvement in data management & integration for Informatica PowerCenter?
- Higher operational costs in the short term
- Enhanced efficiency, quality, and competitive advantage over time (Correct answer)
- Increased complexity in operations
- Reduced need for employee input
Correct answer: Enhanced efficiency, quality, and competitive advantage over time
Continuous improvement systematically enhances efficiency and quality, leading to sustained competitive advantage.
Question 9: In a target reject (.bad) file, what does the column indicator 'T' mean?
- Null value
- Truncated data (Correct answer)
- Valid data
- Overflow
Correct answer: Truncated data
T marks data truncated because it exceeded the target column length.
Question 10: What privilege is required to create and manage deployment groups?
- Create Deployment Groups and Manage Deployment Groups under Global Objects (Correct answer)
- Execute under Run-time Objects
- Access Designer under Tools
- Manage Versions under Design Objects
Correct answer: Create Deployment Groups and Manage Deployment Groups under Global Objects
Deployment groups are global objects, so their creation and management are controlled by Global Objects privileges.
Question 11: Which metric BEST indicates successful project planning & deployment in Informatica PowerCenter?
- Number of meetings held per week
- Achievement of defined key performance indicators and stakeholder satisfaction (Correct answer)
- Hours worked by team members
- Volume of emails sent
Correct answer: Achievement of defined key performance indicators and stakeholder satisfaction
KPI achievement and stakeholder satisfaction directly measure whether management activities are producing desired outcomes.
Question 12: Which option is NOT a valid Lookup Policy on Multiple Match setting?
- Report Error
- Use First Value
- Use Any Value
- Use Average Value (Correct answer)
Correct answer: Use Average Value
Valid settings include First, Last, Any value, Report Error, and Return All Values; there is no averaging option.
Question 13: Which command line program starts a PowerCenter workflow from a scheduler or shell script?
- pmcmd (Correct answer)
- infasetup
- pmpasswd
- pmrep
Correct answer: pmcmd
pmcmd talks to the Integration Service to start, stop, and monitor workflows.
Question 14: What is the main difference between stopping and aborting a session?
- Abort only works on worklets
- Stop finishes processing and committing data already read; Abort kills the DTM process if it hasn't stopped within a timeout (Correct answer)
- Stop discards all data; Abort commits it
- They behave the same
Correct answer: Stop finishes processing and committing data already read; Abort kills the DTM process if it hasn't stopped within a timeout
Abort waits a timeout period (60 seconds) for processing to finish, then kills the DTM process.
Question 15: Which client tool provides real-time monitoring of workflow and session execution?
- Workflow Monitor (Correct answer)
- Designer.
- Workflow Manager.
- Repository Manager.
Correct answer: Workflow Monitor
The Workflow Monitor is the PowerCenter client tool that provides real-time monitoring and management capabilities for workflows and sessions. It allows users to view the status of running, completed, or failed jobs, examine session logs, and troubleshoot issues. This tool offers critical insights into the execution progress and performance of data integration processes.
Question 16: Which PowerCenter domain node receives service requests from client applications and routes them to the correct service?
- Compute node
- Gateway node (Correct answer)
- Worker node
- Backup node
Correct answer: Gateway node
Gateway nodes accept client requests and route them, and one gateway acts as the master gateway for the domain.
Question 17: What is the default port a PowerCenter domain uses for its gateway node?
- 8080
- 1521
- 6005 (Correct answer)
- 4333
Correct answer: 6005
Port 6005 is the default domain port assigned during installation.
Question 18: Which task pauses a workflow until a specific indicator file appears on disk?
- Assignment task
- Decision task
- Timer task
- Event-Wait task (Correct answer)
Correct answer: Event-Wait task
An Event-Wait task can watch for a file to appear before letting the workflow continue.
Question 19: How can a Sorter transformation be configured to eliminate duplicate rows?
- Enable case-sensitive sorting
- Increase the Sorter cache size
- Set the sort direction to descending
- Enable the Distinct option (Correct answer)
Correct answer: Enable the Distinct option
Enabling Distinct makes the Sorter output only unique rows, treating all ports as sort keys.
Question 20: A developer needs to split rows into three target paths based on region codes in a single transformation. Which transformation is best?
- Union
- Router (Correct answer)
- Filter
- Normalizer
Correct answer: Router
A Router evaluates multiple group filter conditions in one transformation and sends rows to each matching output group.
Question 21: Which transformation returns the top or bottom N rows for each group?
- Filter
- Aggregator
- Rank (Correct answer)
- Sorter
Correct answer: Rank
The Rank transformation selects the top or bottom number of rows per group based on a rank port.
Question 22: In a PowerCenter reject file, what does a row indicator value of 3 mean?
- Update
- Delete
- Reject (Correct answer)
- Insert
Correct answer: Reject
Row indicators are 0=insert, 1=update, 2=delete, and 3=reject.
Question 23: What does purging object versions in a versioned repository accomplish?
- Validates all mappings
- Rolls back the last deployment
- Checks in all checked-out objects
- Permanently removes selected older versions to reduce repository size (Correct answer)
Correct answer: Permanently removes selected older versions to reduce repository size
Purging permanently deletes selected versions from the repository, which you cannot undo.
Question 24: Mapping validation fails for an unconnected Lookup transformation. Which requirement is most likely missing?
- A persistent cache file name
- A connected output port to the target
- Exactly one port designated as the return port (Correct answer)
- A lookup override containing ORDER BY
Correct answer: Exactly one port designated as the return port
An unconnected Lookup must have exactly one return port to pass a value back to the calling expression.
Question 25: In a versioned repository, what is the best practice when checking in a changed mapping?
- Undo the checkout and re-import from XML
- Check in only at the end of the project
- Leave the comment blank so it uses a default
- Enter a meaningful check-in comment that describes the change and its reason (Correct answer)
Correct answer: Enter a meaningful check-in comment that describes the change and its reason
Clear check-in comments build an audit trail that shows up in the object's version history.
Question 26: What is the use of the Performance Details tab in Workflow Monitor?
- To analyze session performance (Correct answer)
- To design workflows.
- To schedule tasks.
- To store logs.
Correct answer: To analyze session performance
The Performance Details tab in the Workflow Monitor provides crucial metrics and statistics related to a session's execution, such as throughput, transformation statistics, and resource utilization. This information is invaluable for analyzing session performance and identifying bottlenecks. By examining these details, developers can pinpoint areas for optimization and improve the efficiency of data flows.
Question 27: Which Workflow Monitor view shows task run history along a timeline?
- Output view
- Navigator view
- Task view
- Gantt Chart view (Correct answer)
Correct answer: Gantt Chart view
Gantt Chart view shows workflow and task runs plotted against time.
Question 28: Which component runs on every node in a domain and handles authentication, authorization, and logging?
- Load Balancer
- Web Services Hub
- Service Manager (Correct answer)
- Repository Service
Correct answer: Service Manager
The Service Manager starts on each node and provides core domain functions such as authentication, authorization, and logging.
Question 29: Which port type in an Expression transformation holds a value across rows and can be used to compare the current row with the previous one?
- Variable port (Correct answer)
- Lookup port
- Input port
- Output port
Correct answer: Variable port
Variable ports retain their values across rows, enabling previous-row comparisons.
Question 30: Which tool in PowerCenter helps identify performance bottlenecks?
- Designer.
- Repository Manager.
- Workflow Monitor Performance Details (Correct answer)
- Workflow Manager.
Correct answer: Workflow Monitor Performance Details
The Workflow Monitor's Performance Details tab is the primary tool in PowerCenter for identifying performance bottlenecks. It provides granular statistics on session execution, including read/write throughput, transformation-specific metrics, and resource utilization. By analyzing these details, developers can pinpoint which parts of the data flow are consuming the most time or resources, guiding optimization efforts.
Question 31: When running pmrep ObjectImport, what file defines how conflicts like existing objects are resolved?
- Import control file (Correct answer)
- Session log file
- odbc.ini file
- Parameter file
Correct answer: Import control file
The import control file (XML) specifies folder mapping and conflict resolution rules such as replace, reuse, or rename.
Question 32: How can an administrator restrict which users may run sessions under a given operating system profile?
- Give them Write permission on all folders
- Assign them to the Others group
- Disable LDAP synchronization
- Grant those users permission on the operating system profile (Correct answer)
Correct answer: Grant those users permission on the operating system profile
Users need permission on an operating system profile to assign it to workflows and run sessions with it.
Question 33: Which command-line program performs repository tasks such as creating folders, deploying objects, and backing up the repository?
- pmrep (Correct answer)
- infacmd isp only
- pmcmd
- pmserver
Correct answer: pmrep
pmrep runs repository-related operations such as connect, backup, object import/export, and deployment.
Question 34: In Informatica PowerCenter, how should project planning & deployment challenges be prioritized?
- Based on potential impact, urgency, and alignment with strategic objectives (Correct answer)
- Based solely on cost considerations
- By the preferences of senior management
- In the order they were identified
Correct answer: Based on potential impact, urgency, and alignment with strategic objectives
Prioritizing based on impact, urgency, and strategic alignment ensures resources are directed where they will produce the greatest benefit.
Question 35: Which prefix is standard for a workflow in PowerCenter naming conventions?
- flow_
- wf_ (Correct answer)
- w_
- wkf_
Correct answer: wf_
Workflows are usually named with the wf_ prefix, e.g., wf_Daily_Sales_Load.
Question 36: A developer must ensure flat-file source paths work on every node and in every environment. What is the best practice?
- Use mapped network drive letters
- Copy files to the Informatica installation directory
- Use $PMSourceFileDir or a $InputFile parameter instead of hardcoded absolute paths (Correct answer)
- Hardcode the full UNIX path in the session
Correct answer: Use $PMSourceFileDir or a $InputFile parameter instead of hardcoded absolute paths
Service process variables and file parameters make source paths portable across nodes and environments.
Question 37: What is the purpose of applying a label to object versions before deployment?
- To compress the objects
- To schedule the workflow
- To mark a consistent set of versions, such as a release, that can be queried and deployed together (Correct answer)
- To lock the folder against all reads
Correct answer: To mark a consistent set of versions, such as a release, that can be queried and deployed together
Labels tag specific object versions so a release baseline can be identified, queried, and deployed.
Question 38: What does the 'Stop on errors' session property do when set to 0 (the default)?
- Stops the session after 10 errors
- Disables writing to the reject file
- Never stops the session because of non-fatal errors (Correct answer)
- Stops the session on the first error
Correct answer: Never stops the session because of non-fatal errors
A value of 0 means non-fatal errors never cause the session to stop.
Question 39: Which of the following is a valid reason to keep separate Integration Services for development and production?
- To isolate workloads and limit the impact of development runs on production performance (Correct answer)
- Workflow Monitor only connects to one service per domain
- Integration Services cannot share a repository
- Each mapping requires its own Integration Service
Correct answer: To isolate workloads and limit the impact of development runs on production performance
Separating services isolates resource use, security, and runtime settings so development work does not affect production jobs.
Question 40: To process multibyte character data such as Japanese text, which data movement mode should the Integration Service use?
- Binary
- Unicode (Correct answer)
- Latin-1
- ASCII
Correct answer: Unicode
Unicode mode lets the Integration Service handle multibyte characters, while ASCII mode handles only single-byte data.
Question 41: What is a recommended way to document a mapping's overall purpose, source-to-target logic, and change history inside PowerCenter?
- Fill in the mapping's Description and keep version check-in comments (Correct answer)
- Put notes in the target table name
- Rename every port with long descriptive names
- Add comments only in the session log
Correct answer: Fill in the mapping's Description and keep version check-in comments
The mapping Description and version comments keep documentation stored with the object in the repository.
Question 42: A session rejects several rows at the target. Where does the Integration Service write these rejected rows by default?
- To the source qualifier cache
- To the workflow log
- To the repository's OPB tables
- To a reject (bad) file in $PMBadFileDir (Correct answer)
Correct answer: To a reject (bad) file in $PMBadFileDir
Rejected target rows are written to a reject file, by default in the $PMBadFileDir directory.
Question 43: What does a workflow task represent?
- A type of mapping.
- An individual executable step (Correct answer)
- A repository object.
- A scheduler configuration.
Correct answer: An individual executable step
A workflow task in Informatica PowerCenter represents an individual, executable step within a workflow. These tasks can include running a session (Session task), executing an operating system command (Command task), sending notifications (Email task), or controlling workflow logic (Decision task). Tasks are linked together to define the sequential or conditional flow of operations in a data integration process.
Question 44: Which transformation is used to find and replace values in a data stream?
- Router transformation.
- Filter transformation.
- Normalizer transformation (Correct answer)
- Joiner transformation.
Correct answer: Normalizer transformation
The Normalizer transformation is primarily used to convert denormalized data, often with repeating groups, into a normalized format. It effectively 'finds' data spread across multiple columns in a single row and 'replaces' that structure by creating multiple rows, each containing a single instance of the repeating data. This process transforms the data stream into a more structured and normalized representation.
Question 45: Which transformation allows branching based on multiple conditions?
- Router transformation (Correct answer)
- Joiner transformation.
- Sorter transformation.
- Filter transformation.
Correct answer: Router transformation
The Router transformation in Informatica PowerCenter is used to branch data rows into multiple output groups based on different, user-defined conditions. Unlike a simple Filter, which only passes or drops rows, the Router can direct rows to various distinct pipelines simultaneously. This enables complex conditional data flow and processing based on multiple criteria.
Question 46: An administrator wants AD users to log in to PowerCenter without manually re-creating their accounts. What should they configure?
- A deployment group
- An operating system profile
- A shared folder
- An LDAP security domain with synchronization (Correct answer)
Correct answer: An LDAP security domain with synchronization
An LDAP security domain imports users and groups from the directory service and keeps them synchronized on a schedule.
Question 47: Where should a developer record the business purpose of an individual transformation so that it is stored in the repository?
- In a separate spreadsheet kept on the shared drive
- In the workflow's Email task
- In the session log properties
- In the Description field of the transformation's properties (Correct answer)
Correct answer: In the Description field of the transformation's properties
Each transformation has a Description field that saves documentation with the object's metadata in the repository.
Question 48: A connected Lookup fails with an error when a lookup condition returns multiple rows. Which property change resolves this?
- Set Lookup Policy on Multiple Match to Use First Value, Use Last Value, or Use Any Value (Correct answer)
- Enable Lookup Caching Enabled
- Disable the lookup condition
- Change the Lookup to an unconnected Lookup
Correct answer: Set Lookup Policy on Multiple Match to Use First Value, Use Last Value, or Use Any Value
When the policy is Report Error, multiple matches raise an error; choosing a first/last/any value policy avoids it.
Question 49: Which tracing level logs every row passing through a transformation and is most useful for row-level debugging?
- Terse
- Verbose Initialization
- Normal
- Verbose Data (Correct answer)
Correct answer: Verbose Data
Verbose Data writes each row's data to the session log, making it ideal for debugging but costly for performance.
Question 50: An administrator wants to manage nodes, services, users, and permissions through a web browser. Which tool should be used?
- Repository Manager
- Informatica Administrator (Correct answer)
- Designer
- Workflow Manager
Correct answer: Informatica Administrator
Informatica Administrator is the web-based console for managing the domain, nodes, application services, and security.
Question 51: Which partition type distributes rows to partitions automatically by grouping on the transformation's group-by or sort keys?
- Pass-through
- Hash auto-keys (Correct answer)
- Database partitioning
- Round-robin
Correct answer: Hash auto-keys
Hash auto-keys uses the group-by or sort ports as the hash key so related rows reach the same partition, as Aggregator and Sorter need.
Question 52: Compared with running a workflow on a grid, what does running a session on a grid allow?
- The session skips writing logs
- The session uses the Repository Service for transformations
- Session threads and partitions are distributed across multiple nodes (Correct answer)
- The session runs without a DTM process
Correct answer: Session threads and partitions are distributed across multiple nodes
Session on grid distributes the session's partition groups and threads to multiple DTM processes on different nodes.
Question 53: What is the default commit interval for a session using target-based commit?
- 10,000 rows (Correct answer)
- 1,000 rows
- 100,000 rows
- 50,000 rows
Correct answer: 10,000 rows
The default commit interval is 10,000 rows.
Question 54: In a repository domain with PowerCenter, what is the role of a global repository?
- It caches lookup data for all sessions
- It holds shared objects that registered local repositories can use (Correct answer)
- It stores only session logs
- It replaces the domain configuration repository
Correct answer: It holds shared objects that registered local repositories can use
A global repository holds shared metadata that local repositories registered to it can access through shortcuts.
Question 55: What is a key trade-off of using bulk load mode on a relational target?
- It forces row-by-row commits
- It requires sorted input
- It disables partitioning
- It bypasses the database log, so session recovery is not possible (Correct answer)
Correct answer: It bypasses the database log, so session recovery is not possible
Bulk loading skips redo/transaction logging, improving speed but preventing rollback and recovery.
Question 56: Which link condition makes a downstream task run only when session s_load_dim completes successfully?
- $s_load_dim.ErrorCode = 1
- $s_load_dim.Status = SUCCEEDED (Correct answer)
- $$s_load_dim.Status = 'SUCCESS'
- $s_load_dim.PrevTaskStatus = COMPLETED
Correct answer: $s_load_dim.Status = SUCCEEDED
A link condition checks the task's predefined Status variable against the SUCCEEDED value.
Question 57: What is the effect of unconnected Lookup caching on performance?
- Causes data loss.
- Slows down session.
- Improves performance by caching lookup results (Correct answer)
- No effect on performance.
Correct answer: Improves performance by caching lookup results
Unconnected Lookup transformations, when configured with caching, significantly improve performance by loading the lookup data into memory once at the beginning of the session. Subsequent calls to the unconnected lookup function retrieve data directly from this cache, avoiding repeated database queries. This reduces I/O operations and network traffic, leading to faster data processing.
Question 58: Which client tool is used to design mappings in PowerCenter?
- Designer (Correct answer)
- PowerCenter Server.
- Repository Manager.
- Workflow Monitor.
Correct answer: Designer
The Informatica PowerCenter Designer is the dedicated client tool used by developers to create and design mappings. Within the Designer, users define source and target definitions, drag and drop various transformations, and connect them to visually construct the data flow logic. It is the primary interface for building the core ETL transformation blueprints.
Question 59: For best Joiner performance with unsorted input, which source should be the master?
- Always the relational source
- The source with more rows
- The source with fewer rows (Correct answer)
- The source with more columns
Correct answer: The source with fewer rows
The Joiner caches the master, so a smaller master means a smaller cache and faster join.
Question 60: Adding partitions to a session will most likely NOT improve performance in which case?
- The source and target are large
- The transformations are CPU-bound and CPUs are idle
- The session runs on a multi-CPU server
- The node's CPUs are already fully used (Correct answer)
Correct answer: The node's CPUs are already fully used
More partitions need more CPU and memory, so a node whose CPUs are already maxed out won't get faster.
Informatica PowerCenter Developer Specialist Certification
This certification validates an individual's expertise in developing and implementing data integration solutions using Informatica PowerCenter.
Exam Rules
- You can skip questions and return to them later
- Flag questions for review before submitting
- No feedback shown until you submit the entire exam
- Unanswered questions count as wrong — answer everything
- 10 pretest questions are mixed in and don't affect your score
- Timer auto-submits when time runs out
- Your progress is auto-saved every 30 seconds
Practice questions written with AI assistance and published by Nathan Beja, founder of Practice Test Geeks. They are not real exam questions. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- infa-education.zendesk.com — Fees · verified Nov 2026
- now.informatica.com — Test delivery, exam format, passing score, retake fee, retake policy, time limit, eligibility · verified Nov 2026