1. Terminology and Architecture
- Explain the purpose of Informatica PowerCenter
-Define terms used in PowerCenter
-Name major PowerCenter components and describe their functions
2. Mapping Fundamentals
-Create Source and Target Definition objects from flat files and relational tables.
-Create a Mapping using existing source and target definitions
-Use links to connect ports
3. Workflow basics
-Create a Workflow and link its tasks
-Run a workflow monitors its execution and verify the results
4. Expressions and Filters
-Use expression transformations to perform calculations on a row by row basis
-Use filter transformations to pass rows based on user defined conditions
5. Joining and Merging Data.
-Use pipeline branches in Mappings
-Join homogeneous sources using the source qualifier transformation
-Define heterogeneous joins using the joiner transformation
-Merge records from multiple places to one record set using the Union transformation
6. Lookup Transformation
-Use lookup transformations to bring in additional data related to a row
-Use unconnected lookup transformations to provide values on, as needed basis
7. Sorter and Aggregator Transformations
-Calculate values based on data in a set of records using the Aggregator transformation
-Order a set of records based on one or more fields using the aggregator transformation
8. Updating target tables
-Use an update strategy transformation to determine how the target should handle records (insert, update, delete)
-Use the Debug wizard and toolbar to debug a mapping.
10. Mapping Techniques
-Set and use system and Mapping variables and parameters
-Creates and use reusable’s transformations
-Use a Router transformation to divide a single set of records into multiple sets of records.
11. Mapplets and worklets
-Know how to use mapplet output transformations and output groups.
-Know the rules regarding active and passive mapplets
-Use mapplets in Mappings
12. Controlling workflows
-Set and use workflow variables
-Use link conditions and decision tasks to control the execution of a workflow
-Create and use other workflow tasks including email. Event Wait, Event Raise and Command
-Explain the purpose of the pmomd utility
-Schedule workflow to run automatically
13. Mapping Design
-Follow recommended best practices for Mapping Design
14. Workflow Design.
A follow recommended best practices for workflow design.