ETL TESTING CONTENTS

             AKHIL REDDY TECHNOLOGIES

       8-3-214/3/2/4, above Karachi bakery,

         Opp. Mythrivanam, Ameerpet,Hyd.

DATA WAREHOUSING CONCEPTS

• Introduction to data warehousing

• What is data warehousing?

• What is data warehouse?

• Architecture of data warehousing

• Characteristics of the data warehousing

• What is OLTP?

• What is OLAP?

• DATAMART

• SCEMA

   1) Star Schema

   2) Snow flake schema

   3) Fact construction or galaxy schema

• LANDING FILES

   1) Audit file

   2) Data file

• Dimension table

• SCD (SLOWLY CHANGING DIMENSION)

       1) SCD Type 1

       2) SCD Type 2

       3) SCD Type 3

SQL (STRUCTURAL QUERY LANGUAGE)

• Fundamentals of DBMS

• Data Types in SQL SERVER

• Data Bases in SQL SERVER

• SPECIAL OPERATORS IN SQL SERVER

• T-SQL (TRANSACT STRUCTURED QUERY LANGUAGE

1. DDL (Data Definition Language)
2. DML (Data Manipulation Language)
3. DCL (Data Control Language)
4. TCL (Transaction Control Language)

• JOINS

1. INNER JOIN
2. OUER JOIN
3. CROSS JOIN

• SUB-QUERIES

• GROUP BY CLAUSE:

• HAVING CLAUSE:

• ORDER BY Clause

• VIEWS

• FUNCTIONS

SDLC AND STLC

 • Agile methodology

        Sprint planning meeting

        Standup meeting

        Retrospective meeting

        Sprint born down sheet

        Handover sheet

        Pointer

        Velocity

        Scrum master

        Scrum board

• Waterfall model

• V-model

ETL TESTING CONCEPTS

• ETL TESTING LIFE CYCLE

    Application layer

    Landing area

    Staging area 

     Data provisioning area

    View layer

    Customized view layer

• What is ETL TESTING?

• Responsibilities of ETL TESTING

• How to prepare test plan in ETL?

• How to prepare test strategy in ETL?

• How to prepare test scenario in ETL?

• How to prepare test data in ETL?

• How to design test cases in ETL?

• How to prepare test scripts in ETL?

• How to prepare test environment in ETL?

• Test execution

• BATCH JOB testing

• Sample testing

• Scenario testing

• Inbound testing

• Outbound testing

• Report testing

• Review

• Peer review

• QA deliverables

• VALIDATIONS

   Structured validation

   Count validation

   Primary key validation

   Data validation 

               SMT (SOURCE MINUS TARGET)

               TMS (TARGET MINUS SOURCE)

• DATA MIGRATION TESTING

• Minus query

• Error check

• Duplicate

• RI validation

TERADATA CONCEPTS

• What is TERADATA?

• Why TERADATA?

• History of TERADATA

UNIX

OVERVIEW OF ETL TOOLS

CONTROLE M

DATASTAGE

REALTIME SCENARIOS

RESUME PREPARATION

INTERVIEW TIPS

     

      

9440592994, 8885592994

            040-40032994

        www.akhilreddy.com