QTP Online Trainings From Hyderabad

Sponsored Ads

Price: Free

Contact us:Vani,+91-9949023777, trainings@qtp-onlinetraining.com www.qtp-onlinetraining.com  DATA WAREHOUSING CONCE...

  • Category: Professional & Short Term Course
  • Published: 02/02/2015
  • Current Rating: /5 0 Vote

    Description

    Contact us:


    Vani,


    +91-9949023777,


    trainings@qtp-onlinetraining.com


    www.qtp-onlinetraining.com


     



    • 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


    Phone Number : 9949023777

    Related Ads

    Leave your comment


    Copyright © 2016 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us: query[at]tuffclassified.com