INFORMATION Training Overview
Intrduction
Power Center Components
• Designer
• Repository Manager
• Workflow Manager
• Workflow Monitor
Informatica Concepts and Overview
• Informatica Architecture
• Source Qualifier
• Target Designer
• Transformations
• Mappings
• Mapplets
• Sessions
• Tasks
Sources
• Working with Flat Files
• Working with relational Sources
Targets
Transformations
• Expression Transformation
• Expression Transformation
• Sequence Generator Transformation
• Filter Transformation
• Joiner Transformation
• Sorter Transformation
• Procedural Transformation
• Router Transformation
• Aggregator Transformation
• Update Strategy Transformation
• Union Transformation
• Rank Transformation
• Transaction Control Transformation
• Normalizer Transformation
• Source Qualifier Transformation
• Stored Procedure Transformation
• XML Source Qualifier Transformation
• Debugging Mappings
ADVANCED INFORMATICA CONCEPTS
• Unconnected lookup Transformation
• Mapplet a
• Defining Reusable Transformations
• Tasks And Types of Tasks
• Worklet
• Scheduling Work flow
• Target Load Plan
• Types of Batch Processing
• Link conditions
• Mapping Parameters
• Mapping Variables
• Defining Session Parameters
• PMCMD Utility
• TYPES Of LookUp Caches.
• Static LookUp Cache
• Dynamic LookUp Cache
• Perisistance lookup Cache
• Shared LookUp Cache
Task Types
• Session
• Command
• EMAIL
• Timer
• Event Wait
• Event Raise
• Decision
• Assignment
• Control
• Worklet and basics of datawarehousing concepts