View Course Agenda

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 :

  1. Click Enroll and log in to your Informatica account.
  2. Click Add to Cart and complete your registration/purchase.
  3. Once you have registered go to My Training and View Your Transcript.
  4. Now you can simply Launch and take your test Anytime/Anywhere prior to your test’s expiry date.
The below can be used as a guide to preparing before taking the test. Included is an outline of the technical topics and subject areas that are covered in the test, test domain weighting, test objectives and topical content.

Enroll Now

Target Audience

  • Students seeking certification as a PowerCenter Data Integration Developer Specialist 

Prerequisites

The recommended training prerequisites for Specialist certification are the completion of the following Informatica course(s):

    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

For more information on Informatica Certifications visit https://www.informatica.com/services-and-training/certification.html

To find the class that is right for you, fill out the form at the top of this page, or visit our website at http://www.informatica.com/us/services-and-training/training/. For onsite class information contact your local Education Sales Specialist.


Enroll Now

 


QUESTIONS?

Certification Exam | PowerCenter | Self-Paced

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

For more information on Informatica Certifications visit https://www.informatica.com/services-and-training/certification.html

To find the class that is right for you, fill out the form at the top of this page, or visit our website at http://www.informatica.com/us/services-and-training/training/. For onsite class information contact your local Education Sales Specialist.


Enroll Now

 


Print Friendly and PDF