DWH Concept
- Introduction and Definition
- Sources, Transformations and Targets (Architecture)
- Data Extraction, Data Transformations and Data Loading (Data Acquisition Process)
- Data Warehousing Approaches
- Staging Area, Metadata, Repository and Data Mart
- Data Modeling
- Differences between OLTP and OLAP (DSS) Systems
- Operational Data Store (ODS)
- Business Intelligence
- Star Schema Design & Snow-Flake Scheme
- Junk Dimension Confirmed Dimension, Fact less Fact Table, Types of Facts
- Slowly Changing Dimensions (SCD)
Informatica Concept
- Introduction to INFORMATICA
- ETL process in Informatica
- ETL naming conventions of different vendors
- Informatica Products (Power Center and Powermart)
- Informatica Softwares (Server and Client)
- Informatica Components and sub-components (Server and Client)
- ETL Implementation Tasks in Informatica
- Informatica Architecture
Informatica Transformations
- Source Qualifier
- Filter
- Expression
- Sorter
- Aggregator
- Sequence Generator
- Rank
- Router
- Union
- Joiner
- Lookup
- Stored Procedure
- Update Strategy
- Java
- Transaction Control Transformation
- Normalizer
- XML Source Qualifier
Informatica Advanced Concepts
- Implementing Constraint Based Load Ordering
- Implementing Target Load Plan
- Creating and Implementing Unconnected Lookup
- Creating and Implementing Unconnected Stored Procedure
- Debugging Mapping (Before creation of session and After creation Session)
- Creating and Implementing Reusable Transformation
- Creating and Implementing Mapplet
- Defining and Using Mapping Parameter
- Defining and Using Mapping Variable
- Reusable and Non-Reusable Sessions
- Implementing Pre SQL and Post SQL
- Active and Passive Transformations
- Executing workflow by using pmcmd command
- Scheduling workflow
- SQL Override (SQ as Filter and SQ as a Joiner )
- Creating and using User Defined Function (UDF)
- Slowly Changing Dimensions by wizards( SCD-TYPE1, SCD-TYPE2, SCD-TYPE3 )
- Creating and Implementing Worklet
- Data Extraction from Flatfiles (Fixed width and Delimited)
- Data Extraction from Indirect Files (File Repository)
- Exporting and Importing Mappings
- Creating and Using E-mail task
- Creating and Implementing DYNAMIC LOOKUP
- Implementing CANGE DATA CAPTURES(CDC)
- Note: Manual Implementation of Slowly Changing Dimensions( SCD-TYPE1, SCD-TYPE2, SCD-TYPE3 )
NOTE: After completion of course
- 10 Assignments
- FAQs Review
- Project Explanation
