Introduction

• Overview
• Basic Definitions
• Informatica products
• Informatica Architecture
• Tools and their roles
• Folders-Sub folders
• Power center / Power mart

nfomatica Designer – Introductiion

• Introduction to Designer
• Logon to Designer
• Designer interfaces
• Designer Tools
• Defining Sources
• Database as a source
• Flat File sources
• Defining Targets
• Importing from database
• Creating a new target
• Creating target database objects

Informatica Designer

• Mapping Introduction
• Source Qualifier
• Ports
• Mapping – Table to Table
• Mapping Flat File to Table
• Connected /Unconnected Transformations
• Active and Passive Transformations
• Source Qualifier to join Data
• Filter Transformation
• Expression Transformation
• Sequence Generator Transformation
• Rank Transformation
• Router Transformation
• Aggregator Transformation
• Joiner Transformation
• Stored Procedure Transformation(Connected and Unconnected)
• Union Transformation
• XML Transformation
• Mapping Wizards
• Implementing Type-I,Type-II,Type-III Mappings

Informatica – Workflow Manager

• Workflow Introduction
• Tasks
• Workflow tools
• Connetions
• Defining tasks
• Command Tasks
• Email Task
• Session Task
• Link Conditions
• Event Wait & Event Raise
• Setting Properties of Session Task
• Creating Workflow
• Starting Workflow
• Monitoring Workflow

Informatica Advanced Features

• Incremental Aggregation
• Mapplet Implementation
• Target Load Plan
• Constraint Based Loading
• Mapping Variable
• Session Parameters
• Link Conditions
• Reusable Transformation
• Task and Types of Tasks
• Work let and Types of work lets
• Scheduling Workflow
• Control flow using Command task and event wait task
• Incremental Loading