PowerCenter DI 9x Dev Specialist Skill Set Inventory
PowerCenter DI 9x Dev Specialist Skill Set Inventory
PowerCenter DI 9x Dev Specialist Skill Set Inventory
The skill set inventory is used to guide your preparation before taking the exam. It is an outline of the
technical topics and subject areas that are covered in each exam. The skill set inventory includes test
domain weighting, test objectives and topical content. The topics and concepts are included to clarify
the test objectives.
Test takers will be tested on:
Mapping Design Basic
Mapping Design Advanced
Parameters and Variables
Informatica University, Copyright Informatica Corporation, February 2014
Transformation Language
Troubleshooting
Workflows and Worklets
Training Prerequisites
The skills and knowledge areas measured by this exam are focused on product core functionality inside
the realm of a standard project implementation. Training materials, supporting documentation and
practical experience may become sources of question development.
The recommended training prerequisites for Specialist certification are the completion of the following
Informatica course(s):
PowerCenter 9.x Level 1 Developer
PowerCenter 9.x Level 2 Developer
% of Test
45%
20%
5%
10%
5%
10%
5%
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 a Certified Informatica PowerCenter Data
Integration 9.x: Developer, Specialist.
You are given 90 minutes to complete the exam.
Test formats used in this exam 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
Exam Policy
Test Topics
The exam 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.
SQL Overrides
Stored Procedure Transformation
Unconnected Lookup Transformation
XML Transformation
HTTP Transformation
Transaction Management with Active Transformations
Java Transformation
Normalizer Transformation
SQL Transformation
Variable Assignment
Parameter Files
Transformation Language
Transformation Functions
Troubleshooting
Practical Experience
PowerCenter Workflow Monitor
Log Management
Workflows
Worklets
Workflow Tasks
B.
C.
D.
The order in which the PowerCenter Integration Service encounters variable functions in the mapping may
not be the same for every session run. Why should the SETCOUNTVARIABLE function be used only once in
a pipeline?
Option Text
A.
B.
This may cause inconsistent results when you use the same variable function multiple times in a
mapping
C.
D.
Character day of week, character day of month, and character day of year respectively
B.
Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively
C.
D.
Mapping Design
In a PowerCenter mapping, a database deadlock has been created. What are the results?
Option Text
A.
B.
The mapping fails after the database resilience period has passed.
C.
D.
B.
C.
D.
Gateway Node