Informatica Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

Power Center Components

• Power Center Components

• Designer

• Repository Manager

• Workflow Manager

• Workflow Monitor

Module 2:

Informatica Concepts and Overview

• Informatica Architecture

• Source Qualifier

• Target Designer

• Transformations

• Mappings

• Mapplets

• Sessions

• Tasks

Module 3:

Sources

• Working with relational Sources

• Working with Flat Files

Module 4:

Targets

• Working with Relational Targets

• Working with Flat file Targets

Module 5:

Transformations

• Expression Transformation

• Lookup Transformation

• Sequence Generator Transformation

• Filter Transformation

• Joiner Transformation

• Sorter Transformation

• Procedural Transformation

• Router Transformation

• Aggregator Transformation

• Update Strategy Transformation

• Union Transformation

• Rank Transformation

• Transaction Control Transformation

• Normalizer Transformation

• Source Qualifier Transformation

• Stored Procedure Transformation

• XML Source Qualifier Transformation

• Debugging Mappings

Module 6:

Power Center Transformation Language

• Numeric functions

• String Functions

• Date Functions

• Conversion Functions

• Cleansing Functions

• Aggregate Functions

• User Defined Functions

Module 7:

ADVANCED INFORMATICA CONCEPTS

• Unconnected lookup Transformation

• Unconnected Stored Procedure to Create and Drop Index

• Mapplet and Types of Mapplets

• Defining Reusable Transformations

• User Defined Functions.

• Tasks And Types of Tasks.

• Worklet and Types of Worklets.

• Scheduling Work flow

• Constraint Based Load Ordering.

• Target Load Plan

• Types of Batch Processing

• Link conditions

• Mapping Parameters

• Mapping Variables

• Defining Session Parameters

• Session Recovery

• Difference Between Normal and Bulk Loading

• Push Down Optimization

• PMCMD Utility

• PMREP Utility

• Incremental Aggregation