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)
?
9. Debugger
?
-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
?
-Describe Mapplets
-Know how to use mapplet output transformations and output groups.
-Know the rules regarding active and passive mapplets
-Use mapplets in Mappings
-Describe worklets
?
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. |
