- The course will progress in a logical fashion to introduce the basics and then move towards the most advanced topics like Constraint based load, Incremental Aggregation, PMCMD etc.
- In depth understanding of Data Warehouse systems, ETL and SQL are provided to start with.
- It is a Live teacher led class that encourages participant and teacher interaction
- All the concepts are explained with the help of real time examples.
- Assignments are designed in a way that the theory learned can be easily applied to practical situations.
- Interview Questions are discussed and job-targeted coaching is provided.
- Lectures are available for offline review.
- Resume and job search assistance is provided.
-
Session - 1 DATA WAREHOUSE CONCEPTS & Architecture of Data Warehouse
-
Session - 2 Slowly Changing Dimensions (SCD) & Types of Dimensions and Fact Tables
-
Session - 3 ETL in Bigdata World & Understanding the Role of a Developer
-
Session - 4 Overview of Different Client Tools
-
Session - 5 Mapping Designer and Transformations
- Mapping Designer and Transformations
- Create a Simple Mapping
- Overview of Transformations
- Types of Transformations — Active and Passive
- Expression Transformation
- Source Qualifier Transformation
- Filter Transformation
- Router Transformation
- Aggregator Transformation
- Sorter Transformation
- Reusable Transformation
- Normalizer Transformation
- Union Transformation
- Stored Procedure Transformation
- Sequence Generator Transformation
- Joiner Transformation
- Update Strategy Transformation
- Lookup Transformation
- Static, Dynamic and persistent Lookup Cache
- SCD Type 1 mapping Implementation
- Connected Vs Un-Connected Transformations
- Multiple Pipelines in a Single Mapping
-
Session - 6 Tools for Unit Testing & Different Types of Sources
-
Session - 7 Workflow Tasks & Reusable Features in Informatica
-
Session - 8 Advance Features in Informatica
-
Session - 9 Types of Repositories
-
Session - 10 ETL Testing & Miscellaneous
0.0
0 total
5
4
3
2
1