Scribd
Upload
24 views4 pages

ETL Course

The document outlines a comprehensive course on Data Warehousing, SQL, and Informatica ETL tools, covering key concepts such as ETL operations, data modeling, and various SQL commands. It includes practical aspects of ETL testing methodologies, techniques, and scheduling tools for job management. Additionally, it discusses the types of data marts, dimension and fact tables, and the importance of data quality in testing.

Uploaded by

maheshtester2525
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
24 views4 pages

ETL Course

The document outlines a comprehensive course on Data Warehousing, SQL, and Informatica ETL tools, covering key concepts such as ETL operations, data modeling, and various SQL commands. It includes practical aspects of ETL testing methodologies, techniques, and scheduling tools for job management. Additionally, it discusses the types of data marts, dimension and fact tables, and the importance of data quality in testing.

Uploaded by

maheshtester2525
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 4

Course Overview:

 Data Warehouse
 SQL
 Informatica
 QC Center
 Scheduling Tool for ETL Testing
 2 Project

DATA WAREHOUSE

 What is Data Warehouse.


 Purpose of Data Warehouse.
 What is ETL.
 Overview of ETL Operations.
 ETL Architecture.
 What is Data Mart.
 Types of Data Mart.
 Data Mart vs Data Warehouse.
 What is Dimension Table.
 Types of Dimension Table.
 What is Fact Table.
 Types of Fact Table.
 What is OLAP.
 What is OLTP.
 OLAP vs OLTP.
 What is Data Modeling.
 Types of Data Modeling.
 Star Schema.
 Snow-Flake Schema.
 Normalization and De-Normalization.
 Slowly Changing Dimension (SCD) and Types.
 Uses Of SCD.
 Surrogate Key.

SQL for ETL Testing

 History of SQL
 Introduction of SQL with Oracle Database
 DBMS vs RDBMS
 Data Definition Language Command (DDL)
 Data Manipulation Language Command (DML)
 Transaction Control Language Command (TCL)
 Data Control Language (DCL)
 Data Type
 Aggregate Function
 Character Function
 Date Function
 Where Clause, Having Clause, Group By Clause
 Logical Operator, Comparison Operator
 Constraints
 Case Statement
 Rank & Dense Rank
 Pseudo Columns
 Set Operator
 Joins and Types of Joins
 Equi Join, Non-Equi Join, Cross Join, Self Join, Outer Join, Left Outer Join, etc.
 Difference between inner join and equi join
 Sub Queries
 What is view with real-time example
 Useful SQL query for Data Validation
 Uses of SQL function in transformation.
Informatica ETL tool

 Introduction of Informatica ETL tools


 Introduction of Informatica components
 Power center designer
 Power center workflow Manager
 Power center workflow Monitor
 Mapping
 WorkFlow
 Sessions
 Aggregate Transformation
 Filter Transformation
 Expression Transformation
 Router Transformation
 Joiner Transformation
 Sequence Generator Transformation
 Lookup Expression Transformation
 ETL Test Environment
 Environment With Practical
 ETL Tester Strategy
 ETL Testing Methodology
 ETL Testing Techniques
 ETL Functional Testing
 ETL Performance Testing
 Introduction of Slowly Changing Dimension (SCD)
 SCD Type 1, Type 2, Type 3 Testing
 Initial Load Testing
 Incremental Load Testing
 Surrogate Key & uses
 Testing Surrogate Key
 Testing Technical Attributes & Flags
 Testing Flat file Data
 Testing with different Source and Target
 Constraints Testing
 ETL Integration Testing
 ETL Regression Testing
 ETL System Testing
 UAT Testing
 Designing the Test Cases
 Challenges in DWH Testing
 Data Base Testing vs ETL/ DWH Testing
 About STM/ BRD Document
 Data Quality Rules
 Testing with Different Transformation

Scheduling Tool for ETL Testing

 About Scheduling Tools.


 How to Schedule the Job
 How to Run the Job
 Verifying the Log files in Scheduling Tools

You might also like