INFORMATICA ONLINE TRAINING
Introduction Overview Basic
Data warehousing
Definitions
Various
Informatica products
Informatica Architecture Tools
& their roles
Folders-Sub Power
folders
center / Power mart
Informatica Power Center Designer Introduction Introduction Logon
to Power Center Designer
to Designer
Designer
interfaces
Designer
Tools
Defining
Sources
• Database as a source • Flat File sources Defining
Targets
Importing
from database
Informatica Designer Mapping Source
Introduction
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
Informatica Power Center– Workflow Manager Workflow
Introduction
Tasks Workflow
tools
Connections Defining
tasks
• Comm. & Tasks • Email Task • Session Task • Link Conditions
Informatica Advanced Features Incremental Aggregation Mapplet Target
Implementation
Load Plan
Constraint Mapping Session Link
Based Loading
Variable
Parameters
Conditions
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