In this beginner course I will cover.
1. Basic concepts of ETL, where we will go through the architecture of ETL, where its used, the different types of ETL tools available in the market
2. Introduction to Informaica power center tools. Desginer, workflow manager, Monitor, admin console, repository manager.
3. All the basic transformations like Lookup, joiner, Update stratergy, expression, union, rank, sorter etc.
4. Create 20+ mappings, sessions and workflow, we will also cover the concept of parameter file, indirect files, mapping and workflow variable and parameters.
5. Cover various scenerios based mappings and dicuss logic like how to load data into different type of target, connect to web service, SCD type mappings.
6. Introduction of data modelling and Data warehousing. disucss different type of data model, ERP, Normalization, Data vault 2.0.
7. Hands on and Questions and answers session after each session where you will get hand on with the tool and clarify all the doubts and issues.