Krishna Logo
krishnatraining.com starting new branches in ellicottcity, germantown
Divied
Ria / Kumar @ 1-(877) 864-8462

 

Loading
Latest News
Home Navigation Divied
OFFERED COURSES Navigation Divied ETL TESTING
ETL TESTING
1ETL TESTING COURSE DETAILS

DATA WAREHOUSE FUNDAMENTALS

  • An Introduction of Data warehousing
  • Purpose of Data warehouse
  • Data ware Architecture
  • OLTP Vs Data warehouse Applications
  • Data Marts
  • Data warehouse Lifecycle
  • SDLC
     

DATA MODELING

  • Introduction of Data Modeling
  • Entity Relationship Model
  • Dimensions and Fact Tables
  • Logical Modeling
  • Physical Modeling
  • Schemas Like Star Schema & Snowflake Schemas
  • Fact less Fact Tables


SCD TYPES

  • Type 1 SCD
  • Type 2 SCD
  • Type 3 SCD


PROCESS OF ETL 

  • Introduction of Extraction , Transformation and Loading
  • Types of ETL tools
  • Key tools in the market

ETL TESTING CONCEPTS

  • Purpose of testing
  • How to maintain quality & standards
  • Responsibilities of a ETL Tester

UNDERSTANDING 

  • Analysing the Business Requirement Documents
  • Understanding Mapping sheets
  • Following Job Dependency


SQL CONCEPTS AND CREATING QUERIES

  • Basic Select Statements
  • Creating Sub queries
  • Using Different type of Joins

TESTING METHODOLOGIES

  • ETL Testing Work Flow Process
  • How to Prepare the ETL Test Plan
  • How to design the Test cases in ETL Testing.
  • How to reporting the Bugs in ETL Testing?
  • ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
  • How to detect the bugs through database queries
  • ETL Testing & Performance Tuning
     

UNIX BASICS

  • What is UNIX?
  • How to Create, List Files and directories
  • Displaying or searching the contents of a file
  • Moving files from one directory to another


Training Schedules
VIRGINIA- QA WEEKDAY MORNING
Schedule: Mon, 7 Apr 2014
Apr
07
VIRGINIA-QA WEEKEND MORNING
Schedule: Sat, 3 May 2014
May
03
ONLINE WEEKEND-QA
Schedule: Mon, 5 May 2014
May
05
QA WEEKDAY GERMANTOWN
Schedule: Mon, 31 Mar 2014
Mar
31
VIRGINIA-QA EVENING TRAINING
Schedule: Mon, 28 Apr 2014
Apr
28
BALTIMORE QA TRAINING
Schedule: Sat, 19 Apr 2014
Apr
19
Shadow Bottom
   
© 2005 - 2014 Krishna Training.