Loading demo links...
What to study for each PowerCenter-Data-Integration-10-Developer domain
Architecture and Administration
Domain and node architecture and the Informatica PowerCenter commands used to administer and work with the platform.
Key skills
Domain and node architecture, PowerCenter commands, Service Manager concepts
Mapping Design Basic
Core mapping design: the Designer, Workflow Manager and Workflow Monitor tools, Source Qualifier, Expression, Aggregator, Lookup, Filter, Joiner, Union and Update Strategy transformations, mapplets, user-defined functions, and active versus passive transformations.
Key skills
Designer tools, Source Qualifier, Expression, Aggregator, connected Lookup, Filter, Joiner, Union, Update Strategy, mapplets, UDFs, active vs passive
Mapping Design Advanced
Optimal mapping design: SQL overrides, Stored Procedure, unconnected Lookup and XML transformations, HTTP, transaction management with active transformations, Java, Normalizer and SQL transformations.
Key skills
SQL overrides, stored procedures, unconnected lookups, XML and HTTP transformations, transaction control, Java, Normalizer, SQL transformation
Parameters and Variables
Parameters and variables in mappings and sessions, including variable assignment and parameter files.
Key skills
Variable assignment, parameter files, mapping parameters and variables, persistent variables
Transformation Language
The PowerCenter transformation language: expression syntax and the built-in transformation functions used in expressions.
Key skills
Expression syntax, transformation functions, date and string functions, IIF and DECODE, aggregate function behaviour
Troubleshooting
Troubleshooting from practical experience: the Workflow Monitor, session and workflow logs, and log management.
Key skills
Workflow Monitor diagnostics, session logs, reject files, tracing levels, Debugger
Workflows and Worklets
Workflows and worklets and the workflow tasks used to orchestrate sessions and control execution.
Key skills
Workflows, worklets, session and command tasks, decision and link conditions, workflow variables