Informatica

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

-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 pmomd utility

-Schedule workflow to run automatically

-Follow recommended best practices for Mapping Design

A follow recommended best practices for workflow design.