Informatica PowerCenter Developer Specialist study guide
Informatica PowerCenter Developer Specialist · Work through your exam, one topic at a time.
PowerCenter Data Integration Developer, Professional Certification is the Informatica Professional Certification listed under the Data Integration & Engineering family on Informatica University's certification page. Informatica describes Professional Certifications as role-based exams that "validate the individual's understanding and mastery of Informatica products" and are designed "to measure competencies in specific tasks." The credential therefore targets working PowerCenter developers - people who design mappings, build workflows and keep production sessions running - rather than administrators of other product lines. The Informatica PowerCenter Developer Specialist study guide has 8 sections and about 2,900 words.
01Repository Objects
PowerCenter stores every piece of metadata - source and target definitions, transformations, mapplets, mappings, sessions and workflows - in the repository, a set of relational tables managed by the Repository Service. This domain tests how you organise, version, lock, share and delete those objects.
344 words, about 2 min02Source and Target Definitions
Source and target definitions are the metadata the Integration Service reads from and writes to; this domain tests importing and creating them, Source Qualifier behaviour, flat-file properties and load options. Sources may be relational tables or views, flat files, XML, COBOL/VSAM or application sources such as SAP and Salesforce.
366 words, about 2 min03Mapping Design and Core Transformations
Mapping design is the largest scoring area: you must know when to reach for each core transformation, how ports and expressions evaluate, and how active transformations alter the row stream. Every transformation has input, output, both and variable ports.
378 words, about 2 min04Advanced Transformations
Advanced transformations appear in the harder scenario questions: Rank, Normalizer, Transaction Control, Stored Procedure, SQL and Java. Rank returns the top or bottom N rows per group.
377 words, about 2 min05Mapplets and Reusable Logic
Mapplets package a group of transformations for reuse across mappings, and this domain checks the rules that make a set of transformations legally reusable. A mapplet is a reusable object stored in a folder, containing transformations plus an Input transformation and an Output transformation that expose its ports.
338 words, about 2 min06Workflows, Sessions, Tasks and Scheduling
Workflow Manager turns mappings into executable jobs: workflows contain tasks connected by links, sessions bind a mapping to connections and runtime settings, and the scheduler decides when a workflow runs. A workflow starts with a Start task and contains tasks joined by links.
352 words, about 2 min07Performance Tuning
Performance tuning questions ask you to find the bottleneck and fix it at the right layer: source, target, mapping, session or database. Run the session and read Workflow Monitor's performance details: rows per second for the reader, the writer and each transformation.
349 words, about 2 min08Error Handling and Recovery
Sessions fail for predictable reasons - bad data, constraint violations, deadlocks, connectivity - and this domain tests how you detect, contain and restart them. The Expression transformation provides ERROR('message'), which raises a row error and continues, and ABORT('message'), which stops the session.
396 words, about 2 min