Andaman and Nicobar Islands Andhra Pradesh Arunachal Pradesh Assam Bihar Chandigarh Chhattisgarh Dadra and Nagar Haveli Daman and Diu Delhi Goa Gujarat Haryana Himachal Pradesh Jammu and Kashmir Jharkhand Karnataka Kerala Lakshadweep Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Nagaland Orissa Pondicherry Punjab Rajasthan Sikkim Tamil Nadu Tripura Uttar Pradesh Uttarakhand West Bengal
-
Free

ETL Testing Online Training from Hyderabad

Ad ID: 15433 February 4, 2015 32 views

Description

Contact us:
Vani,
+91-9949023777,
trainings@loadrunneronlinetrainings.com
www.loadrunneronlinetrainings.com

ETL Testing Online Training from Hyderabad
Course Content
DATA WAREHOUSING CONCEPTS:
DBMS and RDBMS
What is Data Warehousing and necessity of it?
Data warehousing architecture
OLAP,ROLAP, MOLAP
Data mining
Meta data
Tables, views
Constraints
Fact and Dimensional Tables
Partitioning of tables
Concepts of Referential Integrity
Concepts of Modelling
Database Schema
Concepts of normalization
Concepts of Slowly Changing Dimensions
Concepts of Data Mart
Full and Incremental extraction Process
Change Data capture
SQL CONCEPTS:
DDL, DML commands
All the basic functions (Character Functions, Conversion Functions, Advanced functions, Mathematical Functions and Date Functions)
Joins
Practice SQLs for some sample test scenarios
ETL TESTING:
What is ETL and importance of ETL testing?
Creating, running and analysing sessions/workflows in Informatica
Preparation of Test strategy, Test plan and estimations
Testing scenarios, creation of test cases and scripts
Test case execution and defect tracking and reporting
REPORT TESTING:
Validation of the report data with DB and UI testing
Preparation of Test data
LEVELS OF TESTING
Unit testing
Integration testing
Module testing
System testing
UAT
PRACTICE SESSIONS ON ETL TESTING

    Contact publisher

    Contact publisher
    Enter the words above: