| Module | Topics |
| Data Warehousing Basic Concepts | Data Warehousing Basic Concepts |
| What is Data Warehouse |
| What is Data warehousing? |
| Characteristics of Data warehouse |
| Principles of Data warehouse. |
| Benefits of DWH. |
| What is Data scrubbing, Data Transformation etc |
| What is online transactional systems (OLTP) |
| Difference between OLTP and DWH. |
| Approaches of Data warehousing. |
| DWH Lifecycle |
| Data Warehouse Modeling |
| Staging Area |
| Dimension table |
| Fact Table |
| Schemas |
| Star schema |
| Snowflake schema |
| Slowly changing Dimension Concepts |
| SCD-1 |
| SCD-2 |
| SCD-3 |
| Data Mart |
| Top down Approach |
| Top UP Approach |
| Product Overview | Introduction |
| Sources |
| Targets |
| PowerCenter Repository |
| PowerCenter Client Components |
| Power Center Server Components |
| PowerCenter Designer |
| Repository Manager |
| Workflow Manager |
| Workflow Monitor |
| PowerCenter Repository Service |
| PowerCenter Integration Service |
| Before You Begin | Getting Started |
| Using the PowerCenter Client /Workflow/Monitor/Repository |
| Informatica architecture component wise |
| Use of ODBC/Relational Connection |
| Software Installation and Administrator |
| Work around with Tool | Connecting to the Repository |
| Creating a Folder |
| Changing Password |
| Creating Source Definitions |
| Creating Target Definitions and Target Tables |
| Creating Target Definitions |
| Creating a Mapping |
| Creating Transformations |
| Creating Sessions and Workflows |
| Configuring Relational Connection in the Workflow Manager |
| Creating a Workflow |
| Running and Monitoring Workflows |
| Fetching Session Log |
| Getting Run Properties |
| Working With Files (Source/Target) |
| Working with Fixed width files |
| Working with Delimited files |
| Working with XML Files |
| Transformations | Definition of Transformation |
| Types of Transformation |
| Active/Passive Transformation |
| Reusable and Non-Reusable Transformation |
| Filter Transformation |
| Router Transformation |
| Expression Transformation |
| Rank Transformation |
| Sorter Transformation |
| Aggregator Transformation |
| Sequence Generator Transformation |
| Joiner Transformation |
| Union Transformation |
| Update Strategy Transformation |
| Lookup Transformation |
| Stored Procedure Transformation |
| Normalizer Transformation |
| Source Qualifier Transformation |
| Transaction Control Transformation |
| XML Source Qualifier Transformation |
| SQL Transformation |
| Unconnected Stored Procedure Transformation |
| Unconnected Lookup Transformation |
| Advanced ETL | Working with Parameters/Variables (Mapping/Session/Workflow) |
| Scheduling |
| Debugging |
| Session Properties |
| Error Handling |
| Analyzing Workflow and Session Logs |
| Performance Tuning |
| Unit Testing |
| Export/Import (Backup/Restore) |
| User Defined Function |
| Worklet |
| Reusable and Non Reusable Sessions |
| Implementing SCD1, SCD2, SCD3 |
| Task |
| Reusable and Non Reusable Task |
| Session Task |
| Command Task |
| Email Task |
| Decision Task |
| Assignment Task |
| Timer Task |
| Event Wait Task |
| Event Raise Task |
| Control Task |
| Link Task |
| Partitioning |
| Push Down Optimization (PDO) |
| Target Load Plan |
| Constraint Based Load Ordering |
| ETL Life Cycle |
