Course Content
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 relational Sources
- Working with Flat Files
Targets
- Working with Relational Targets
- Working with Flat file Targets
Transformations
- Expression Transformation
- Lookup 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
Power Center Transformation Language
- Numeric functions
- String Functions
- Date Functions
- Conversion Functions
- Cleansing Functions
- Aggregate Functions
- User Defined Functions
ADVANCED INFORMATICA CONCEPTS
- Unconnected lookup Transformation
- Unconnected Stored Procedure to Create and Drop Index
- Mapplet and Types of Mapplets
- Defining Reusable Transformations.
- User Defined Functions.
- Tasks And Types of Tasks.
- Worklet and Types of Worklets.
- Scheduling Work flow
- Constraint Based Load Ordering.
- Target Load Plan
- Types of Batch Processing
- Link conditions
- Mapping Parameters
- Defining Session Parameters
- Session Recovery
- Difference Between Normal and Bulk Loading.
- Push Down Optimization.
- PMCMD Utility
- PMREP Utility
- Incremental Aggregation
- TYPES Of LookUp Caches.
- Static LookUp Cache
- Dynamic LookUp Cache
- Perisistance lookup Cache
- Shared LookUp Cache
- Sorter and Rank Cache.
- ETL UNIT Testing (8 test Cases)
- ETL PERFORMANCE TESTING (3 test cases)
- ETL Performance Optimization techniques
- Task Implementations.
- Session
- Command
- Timer
- Event Wait
- Event Raise
- Decision
- Assignment
- Control
- Worklet
