ETL Testing

ETL Testing Online Training

i-Edge Solution is one of the best training institute in leading IT online training. We provide best ETL Testing online training with our highly professional real-time trainers. Running ETL Testing results in dramatically improved performance, simplified administration and streamlined IT landscape resulting in lowering total cost of ownership. i-Edge Solution also does corporate training and help them to train their employees.

ETL Testing Online Training

SCD(slowly changing dimension)
  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD
  • Basic Concepts in SQL
  • Overview of ETL Tool Architecture
  • White Box and Black BOX Testing Functionality on Different Transformation Rules
  • Data Ware House Life Cycle
  • Different Types of Testing Techniques in ETL
  • Minus Queuing
  • Count Queuing
Data Ware Housing Concepts
  • What is Data Ware House?
  • Difference between OLTP and Data Ware Housing
  • Data Acquisition
  • Data Extraction
  • Data Transformation
  • Data Loading
  • Data Marts
  • Dependent Data Mart
  • Independent Data Mart
  • Data Base Design
  • Star Schema
  • Snow Flake Schema
  • Fact Constellation Schema
ETL Testing Concepts
  • Introduction
  • what is the use of testing
  • what is quality & standards
  • Responsibilities of an ETL Tester
Software development lifecycle
    Waterfall model
  • V-model
  • Agile model & methodology
  • Prototype model
  • Spiral model
Testing methodologies
  • White box testing
  • Black box testing
  • Grey box testing
  • ETL Testing Work Flow Process
  • How to Prepare the ETL Test Plan
  • How to design the Test cases in ETL Testing.
  • How to report the Bugs in ETL Testing?
  • ETL Testing Responsibilities in Data Stage, Informatica, Abinitio etc
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning

Overview

It is used for developing the distributed applications. The Java Platform, Enterprise Edition or Java EE has undergone several changes since Java J2EE-1.0 as well as numerous additions of new specifications Java Enterprise Level Solutions which are Robust, Scalable and which can fulfill the demands to the Enterprise. Java EE is a normal, robust, scalable, and secure platform

Modules

  • JDBC
  • SERVLET
  • XML
  • EJB
  • J2EE
  • HIBERNATE
  • CORE J2EE DESIGN PATTERNS
  • RMI
  • JSP
  • WEBLOGIC
  • STRUTS
  • AJAX