iNEWPM

Course Details

ETL Testing – Informatica with DWH Concepts

Course Content

I.           Database/SQL

·        RDBMS Concepts

o   Data Models

o   Entity Relationship Model

o   Normalization

o   DBMS, RDBMS, ORDBMS

·        SQL Overview

o   Introduction to SQL

o   Data types

o   SELECT Statement

o   Operators

o   Pseudo Column

·        SQL Statements

o   Data Definition Language (DDL)

o   Data Manipulation Language (DML)

o   Transaction Control Language (TCL)

o   Data Control language (DCL)

·        Join

o   Inner/Equi Join

o   Non-Equi/Cross Join

o   Self Join

o   Outer Join

·        Constraints

o   Primary Key Constraint

o   Foreign Key Constraint

o   Unique Key Constraint

o   Not Null Constraint

o   Check Constraint

·        Set Operator

o   Union

o   Union All

o   Intersection

o   Minus

·        Sub Query

o   Sub/Inner Query

o   Correlated Sub Query

·        Object

o   Index

o   Synonym

o   View

·        Built-in Functions

o   Aggregate Functions

o   Character Function

o   String Functions

o   Case Manipulation Functions

o   Date Functions

o   Analytical Functions

 

II.           Datawarehousing/ETL

·        Datawarehousing Fundamental

o   Datawarehousing Overview

o   DWH Characteristics

o   Types of Datawarehousing

o   Data Mart

o   Database vs Data Warehouse

o   Data Mart vs Data Warehouse

o   Data Warehouse benefits

o   DWH Architecture

·        Datawarehousing Terminologies

o   Data Cleansing, Partitioning

o   Staging area, Metadata

o   OLTP, OLAP, ROLAP, MOLAP

o   Surrogate Key

o   Snapshot, View and Materialized View

o   Meta Data, Data Mining & Data Cube

·        Dimension Modeling

o   Facts and Dimensions

o   Hierarchies and Levels

o   Measures & DWH Schema

o   Star, Snow-flake and Galaxy Schema

o   Additive, Semi Additive, Non Additive Fact/Measure

·        ETL Overview

o   Process Flow of ETL

o   Types of Sources and Target

o   ETL Data Load types

o   Active vs Passive transformation

o   Extraction Methods in ETL

o   Tracing Level

o   Types of Data used for ETL Process

·        Slowly Changing Dimension

o   What is Slowly Changing Dimension?

o   SCD Types : Type-1, Type-2, Type-3

·        ETL Testing Process

o   Categories of ETL Testing

o   Types of ETL Testing

o   How to create ETL Test Case

Are you providing Training Classes
IT Courses / Govt Exam Preparation
Higher Studies / Studies Abroad
NEWFreeCompanies HiringUpdates//nuPM