best informatica online training | informatica training Tutorial

1
INFORMATICA ONLINE TRAINING
2
Introduction

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

3
Informatica Power Center Designer Introduction

• Introduction to Power Center Designer
• Logon to Designer
• Designer interfaces
• Designer Tools
• Defining Sources
• Database as a source
• Flat File sources
• Defining Targets
• Importing from database

4
Informatica Designer

• Mapping Introduction
• Source Qualifier
• Ports
• Mapping DB-Table to DB-Table
• Mapping Flat File to DB-Table
• Connected  and Unconnected Transformations
• Active    Passive Transformations
• Source Qualifier to join Data
• Filter Transformation
• Expression Transformation

5
(No Transcript)
6
Informatica Power Center Workflow Manager

• Workflow Introduction
• Tasks
• Workflow tools
• Connections
• Defining tasks
• Comm.  Tasks
• Email Task
• Session Task
• Link Conditions

7
Informatica Advanced Features

• Incremental Aggregation
• Mapplet Implementation
• Target Load Plan
• Constraint Based Loading
• Mapping Variable
• Session Parameters
• Link Conditions

8
(No Transcript)
9
Lookup Caching, More Features and Techniques

•  Lookup Caching    Lab A Load Promotions
  Dimension Table    Lab B Features and
  Techniques II    Review and more Lab Activities
  and Real time
• issues

10
(No Transcript)