ExpertsExchange - INFORMATICA Training

Topics

• Purpose of Informatica Power Center.
• Terms used in PowerCenter.
• Major PowerCenter components and their functions.

• Creating Source and Target definition objects from flat files and relational tables.
• Creating Mapping using existing Source and Target definitions.
• Using links to connect ports.

• Creating a Workflow and linking its tasks.
• Run a Workflow, monitor its execution, and verify the results.

• Use Expression transformations to perform calculations on a row-by-row basis.
• Use Filter transformations to pass rows based on some user defined condition.

• 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.

• Use Lookup transformations to bring in additional data related to a row
• Use unconnected Lookup transformations to provide values on an as-needed basis

• Purpose of Informatica Power Center.
• 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.

• 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.

• Set and use system and Mapping variables and parameters.
• Create and use reusable transformations.
• Use a Router transformation to divide a single set of records into multiple sets of records.

• 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.

• 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 pmcmd utility
• Schedule workflows to run automatically

• Recommended best practices for Mapping design

• Recommended best practices for Workflow design