Classroom Instructor-led training (CILT) |
Online Instructor-led training ( OILT)
- Explain the purpose of Informatica PowerCenter
-Define terms used in PowerCenter
-Name major PowerCenter components and describe their functions
-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
-Create a Workflow and link its tasks
-Run a workflow monitors 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 user defined conditions
-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, as needed basis
-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
-Creates and use reusable’s transformations
-Use a Router transformation to divide a single set of records into multiple sets of records.
-Know how to use mapplet output transformations and output groups.
-Know the rules regarding active and passive mapplets
-Use mapplets in Mappings
-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
-Follow recommended best practices for Mapping Design
A follow recommended best practices for workflow design.