Informatica
Module 1: Data Warehousing Concepts
- Data Warehouse
- Data Mart
- OLAP VS OLTP
- Data Warehouse Architecture (Basic)
- Data Warehouse Architecture (with a Staging Area)
- Dimensional Modeling
- Star Schema
- Snowflake Schema
- Dimension
- Fact
- Slowly Changing Dimension(Type 1,2 and3)
- Hierarchy
- Confirmed Dimension
- Fact less Fact Table.
- Summary / Aggregations table
- Change Data capture
Module 2: Power Center Components
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
Module 3: Informatica Concepts and Overview
- Informatica Architecture.
- Source Qualifier
- Target Designer
- Transformations
- Mappings
- Mapplets
- Sessions
- Tasks
Module 4: Sources
- Working with relational Sources
- Working with Flat Files
Module 5: Targets
- Working with Relational Targets
- Working with Flat file Targets
Module 6: 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
Module 7: Power Center Transformation Language
- Numeric functions
- String Functions
- Date Functions
- Conversion Functions
- Cleansing Functions
- Aggregate Functions
- User Defined Functions
Module 8: 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
- Mapping Variables
- Defining Session Parameters
- Session Recovery
- Difference Between Normal and Bulk Loading
- Push Down Optimization
- PMCMD Utility
- PMREP Utility
- Incremental Aggregation
Module 9: TYPES Of LookUp Caches
- Static LookUp Cache
- Dynamic LookUp Cache
- Persistence lookup Cache
- Shared LookUp Cache
- Sorter and Rank Cache
Module 10: Task Types
- Session
- Command
- Timer
- Event Wait
- Event Raise
- Decision
- Assignment
- Control
- Worklet
Module 11: ETL Testing
- UNIT Testing
- System Integration testing
- PERFORMANCE TESTING
- ETL Performance Optimization techniques