| Informatica 7.1.1 |
| 1.Introduction |
- Overview
- Basic Definitions
- Informatica products
- Informatica Architecture
- Tools and their roles
- Folders-Sub folders
- Power center / Power mart
|
| 2.Infomatica 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
|
| 3.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
|
| 4.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
|
| 5.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
|
  |
