PowerCenter Data Integration 10: Developer, Specialist Certification
Certification Exam | PowerCenter | Self-Paced
PowerCenter Data Integration 10: Developer, Specialist Certification
Course Overview
This test measures your competency in building PowerCenter objects on basic and advanced levels in order to make optimal use of the Designer, Workflow Manager, and Workflow Monitor tools. Additionally, you will be tested on your ability to use transformations, build and run workflows, and further test your abilities to work as part of a data integration development team.
When you are ready to test and become an Informatica Certified Specialist (ICS), please follow these steps :
- Click Enroll and log in to your Informatica account.
- Click Add to Cart and complete your registration/purchase.
- Once you have registered go to My Training and View Your Transcript.
- Now you can simply Launch and take your test Anytime/Anywhere prior to your test’s expiry date.
Target Audience
- Students seeking certification as a PowerCenter Data Integration Developer Specialist
Prerequisites
- PowerCenter: Data Integration for Developers (Instructor Led) OR PowerCenter: Developer, Level 1 (onDemand)
- PowerCenter: Developer, Level 2 (Instructor Led or onDemand)
Skill Set Inventory |
||
Test takers will be measured on:
- Basic Mapping Design
- Optimal Mapping Design
- Parameters and Variables
- Transformation expression syntax
- Troubleshooting
- Workflows and Worklets
- Architecture and Administration
Test Domains
The test domains and the extent to which they are represented as an estimated percentage of the test follows:
| Title | % of Test |
| Architecture and Administration | 3% |
| Mapping Design Basic | 49% |
| Mapping Design Advanced | 14% |
| Parameters and Variables | 9% |
| Transformation Language | 9% |
| Troubleshooting | 7% |
| Workflows and Worklets | 10% |
Question Format
You may select from one or more response offerings to answer a question.
You will score the question correctly if your response accurately completes the statement or answers the question. Incorrect distractors are given as possible correct answers so that those without the required skills and experience may wrongly select that choice.
A passing grade of 70% is needed to achieve recognition as an Informatica Certified Specialist (ICS) in PowerCenter Data Integration Developer.
You are given 90 minutes to complete the test. Formats used in this test are:
- Multiple Choice: Select one option that best answers the question or completes the statement
- Multiple Response: Select all that apply to best answer the question or complete the statement
- True/False: After reading the statement or questions select the best answer
Test Policy
- You are eligible for one attempt and re-take, if needed, per test registration.
- If you do not pass on your first attempt:
- The purchase of the test will include one second-attempt if a student does not pass a test.
- You must wait two weeks after a failed test to take the test again.
- Any additional retakes are charged the current fee at the time of purchase.
- Promotions are excluded and cannot be combined.
Test Topics
The test will contain 70 questions comprised of topics that span across the sections listed below. In order to ensure that you are prepared for the test, review the subtopics with each section.
Basic Mapping Design
- Use of the PowerCenter Designer Tool
- Use of the PowerCenter Workflow Manager Tool
- User of the PowerCenter Workflow Monitor Tool
- Source Qualifier Transformation
- Expression Transformation
- Aggregator Transformation
- Lookup Transformation
- Filter Transformation
- Joiner Transformation
- Union Transformation
- Update Strategy Transformation
- Mapplets
- User Defined Functions
- Active versus Passive transformations
Optimal Mapping Design
- SQL Overrides
- Stored Procedure Transformation
- Unconnected Lookup Transformation
- XML Transformation
- HTTP Transformation
- Transaction Management with Active Transformations
- Java Transformation
- Normalizer Transformation
- SQL Transformation
Parameters and Variables
- Variable Assignment
- Parameter Files
Expression syntax
- Transformation Functions
Troubleshooting
- Practical Experience
- PowerCenter Workflow Monitor
- Log Management
Workflows and Worklets
- Workflows
- Worklets
- Workflow Tasks
Architecture
- Domain and Node Architecture
- Informatica PowerCenter Commands
Sample Test Questions
| Which of the following is the default Transaction Control transformation variable value? | ||
| A. | X | TC_COMMIT_BEFORE |
| B. | X | TC_COMMIT_AFTER |
| C. | X | TC_ROLLBACK_BEFORE |
| D. | Correct | TC_CONTINUE_TRANSACTION |
| Which one of the following transformations may be unconnected in a valid mapping?(choose one) | ||
| A. | Correct | Lookup |
| B. | X | Lookup and Source Qualifier |
| C. | X | Lookup and Transaction Control |
| D. | X | Lookup, Source Qualifier, or Transaction Control |
| A Web Service Hub can be associated with more than one PowerCenter Repository Service. | ||
| A. | Correct | True |
| B. | X | False |
| In which of the following selections are all of thetransformations active? | ||
| A. | Correct | Router, Update Strategy, Joiner |
| B. | X | Expression, Router, Joiner |
| C. | X | Update Strategy, Expression, Aggregator |
| D. | X | Stored Procedure, Joiner, Router |
| Which transformations contain the Transformation Scope property? | ||
| A. | X | Filter, Joiner, Rank |
| B. | Correct | The Aggregator, Joiner, Rank, Sorter |
| C. | X | Union, Filter, Aggregator |
| D. | X | Rank, Lookup, Aggregator |
Additional Information
Retake Policy: Current purchases of the test will include one second-attempt if a student does not pass a test. Any additional retakes are charged the current fee at the time of purchase. Promotions are excluded and cannot be combined. You must wait two weeks after a failed test to take the test again.
Informatica University has a community page so students can assist one another in their test preparation within the Informatica Network: https://network.informatica.com/welcome
QUESTIONS?
Certification Exam | PowerCenter | Self-Paced
- Basic Mapping Design
- Optimal Mapping Design
- Parameters and Variables
- Transformation expression syntax
- Troubleshooting
- Workflows and Worklets
- Architecture and Administration
Test Domains
The test domains and the extent to which they are represented as an estimated percentage of the test follows:
| Title | % of Test |
| Architecture and Administration | 3% |
| Mapping Design Basic | 49% |
| Mapping Design Advanced | 14% |
| Parameters and Variables | 9% |
| Transformation Language | 9% |
| Troubleshooting | 7% |
| Workflows and Worklets | 10% |
Question Format
You may select from one or more response offerings to answer a question.
You will score the question correctly if your response accurately completes the statement or answers the question. Incorrect distractors are given as possible correct answers so that those without the required skills and experience may wrongly select that choice.
A passing grade of 70% is needed to achieve recognition as an Informatica Certified Specialist (ICS) in PowerCenter Data Integration Developer.
You are given 90 minutes to complete the test. Formats used in this test are:
- Multiple Choice: Select one option that best answers the question or completes the statement
- Multiple Response: Select all that apply to best answer the question or complete the statement
- True/False: After reading the statement or questions select the best answer
Test Policy
- You are eligible for one attempt and re-take, if needed, per test registration.
- If you do not pass on your first attempt:
- The purchase of the test will include one second-attempt if a student does not pass a test.
- You must wait two weeks after a failed test to take the test again.
- Any additional retakes are charged the current fee at the time of purchase.
- Promotions are excluded and cannot be combined.
Test Topics
The test will contain 70 questions comprised of topics that span across the sections listed below. In order to ensure that you are prepared for the test, review the subtopics with each section.
Basic Mapping Design
- Use of the PowerCenter Designer Tool
- Use of the PowerCenter Workflow Manager Tool
- User of the PowerCenter Workflow Monitor Tool
- Source Qualifier Transformation
- Expression Transformation
- Aggregator Transformation
- Lookup Transformation
- Filter Transformation
- Joiner Transformation
- Union Transformation
- Update Strategy Transformation
- Mapplets
- User Defined Functions
- Active versus Passive transformations
Optimal Mapping Design
- SQL Overrides
- Stored Procedure Transformation
- Unconnected Lookup Transformation
- XML Transformation
- HTTP Transformation
- Transaction Management with Active Transformations
- Java Transformation
- Normalizer Transformation
- SQL Transformation
Parameters and Variables
- Variable Assignment
- Parameter Files
Expression syntax
- Transformation Functions
Troubleshooting
- Practical Experience
- PowerCenter Workflow Monitor
- Log Management
Workflows and Worklets
- Workflows
- Worklets
- Workflow Tasks
Architecture
- Domain and Node Architecture
- Informatica PowerCenter Commands
Sample Test Questions
| Which of the following is the default Transaction Control transformation variable value? | ||
| A. | X | TC_COMMIT_BEFORE |
| B. | X | TC_COMMIT_AFTER |
| C. | X | TC_ROLLBACK_BEFORE |
| D. | Correct | TC_CONTINUE_TRANSACTION |
| Which one of the following transformations may be unconnected in a valid mapping?(choose one) | ||
| A. | Correct | Lookup |
| B. | X | Lookup and Source Qualifier |
| C. | X | Lookup and Transaction Control |
| D. | X | Lookup, Source Qualifier, or Transaction Control |
| A Web Service Hub can be associated with more than one PowerCenter Repository Service. | ||
| A. | Correct | True |
| B. | X | False |
| In which of the following selections are all of thetransformations active? | ||
| A. | Correct | Router, Update Strategy, Joiner |
| B. | X | Expression, Router, Joiner |
| C. | X | Update Strategy, Expression, Aggregator |
| D. | X | Stored Procedure, Joiner, Router |
| Which transformations contain the Transformation Scope property? | ||
| A. | X | Filter, Joiner, Rank |
| B. | Correct | The Aggregator, Joiner, Rank, Sorter |
| C. | X | Union, Filter, Aggregator |
| D. | X | Rank, Lookup, Aggregator |
Additional Information
Retake Policy: Current purchases of the test will include one second-attempt if a student does not pass a test. Any additional retakes are charged the current fee at the time of purchase. Promotions are excluded and cannot be combined. You must wait two weeks after a failed test to take the test again.
Informatica University has a community page so students can assist one another in their test preparation within the Informatica Network: https://network.informatica.com/welcome
