Informatica
Training Syllabus
Data Warehouse
Introduction
Power Center Components
·
Designer
·
Repository
Manager
·
Workflow
Manager
·
Workflow
Monitor
·
Power
Center Admin Console
Informatica Concepts and
Overview
·
Informatica
Architecture.
Sources
·
Working
with relational Sources
·
Working
with Flat Files
Targets
·
Working
with Relational Targets
·
Working
with Flat file Targets
Transformations – Active
and Passive Transformations
·
Expression
·
Lookup –Different
types of lookup Caches
·
Sequence
Generator
·
Filter
·
Joiner
·
Sorter
·
Rank
·
Router
·
Aggregator
·
Source
Qualifer
·
Update
Strategy
·
Normalizer
·
Union
·
Stored
Procedure
·
Slowly
Changing Dimension
·
SCD
Type1
·
SCD
Type2 — Date, Flag and Version
·
SCD
Type3
Workflow Manger
·
Creating
Reusable tasks
·
Workflows,
Worklets& Sessions
·
Tasks
·
Session
·
Decision
task
·
Control
Task
·
Event
wait task
·
Timer
task
·
Monitoring
workflows and debugging errors
Indirect Loading
Constraint based load
ordering
Target Load plan
Worklet ,Mapplet ,Resuable
transformation
Migration –XML migration
and Folder Copy.
Scheduling Workflow
Parameter and variables
XML Source, Target and
Transformations
Performance Tuning
·
Pipeline
Partition
·
Dynamic
Partition
·
Pushdown
optimization