EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Data Warehouse Tutorial Data Warehouse Testing
Secondary Sidebar
Data Warehouse Tutorial
  • Basic
    • What is Data Warehouse
    • Data Warehouse tools
    • Career in Data Warehousing
    • Benefits of Data Warehouse
    • Data Warehouse Architecture
    • Data Warehouse Design
    • Data Warehouse Implementation
    • Data Warehouse Features
    • Data Warehouse Modeling
    • Data Warehouse Software
    • Data Warehousing
    • Types of Data Warehouse
    • 10 Popular Data Warehouse Tools
    • Data Lake Architecture
    • Three Tier Data Warehouse Architecture
    • Data Warehouse Process
    • Database Parallelism
    • What is OLTP
    • What is OLAP
    • OLAP Tools
    • Types of OLAP
    • Operations in OLAP
    • MOLAP
    • HOLAP
    • Data Warehouse Schema
    • Data Warehouse Components
    • Snowflake Schema
    • Snowflake Architecture
    • What is Star Schema
    • Galaxy Schema
    • What is Fact Table
    • Kimball Methodology
    • Data Warehouse Testing
    • Operational Data Stores
  • ETL
    • What is Data Mart
    • What is Data Cube
    • What is a Data Lake
    • What is Data Integration
    • What is ETL
    • What is ETL Testing
    • ETL Testing Tools
    • ETL architecture
    • Dimension Table
    • Multidimensional Data Model
    • Fact Constellation Schema
    • ETL Process
  • Interview Questions
    • Data Warehouse Interview Questions
    • ETL Interview Questions
    • ETL Testing Interview Questions
    • Data Warehousing Interview Questions

Related Courses

Business Intelligence Course

All in One Data Science Course

Data Visualization Certification Courses

Data Warehouse Testing

By Priya PedamkarPriya Pedamkar

Data-Warehouse-Testing

Introduction to Data Warehouse Testing

Data Warehouse Testing is a series of Verification and Validation activities performed to check for the quality and accuracy of the Data Warehouse and its contents, where the activities need to be focused mainly on the Data, which should commence as a sequence of evaluation like comparing the huge quantities of data, validating the data from multiple different varieties of sources, ETL testing process for the data using SQL queries, Business Intelligence Testing is applied for validating the Functionality, Security and Performance of the Data Warehouse, determining the capability of the Data Warehouse in supporting Analysis and Report generation, etc.

Data Warehouse Testing Methods

Testing is a word which widely used to check the quality of products and correct if any defects are identified. There are three basic levels of testing.

Data Warehouse

1. Unit Testing

  • Unit testing can be performed by the developers.
  • It will be tested by each component separately.
  • g., Procedure, Program, Scripts, Shell, etc.

2. Integration Testing

  • The various modules are brought together and testes against each input.
  • It will test whether it is good for integration.

3. System Testing

  • It can be tested for the whole application.
  • The purpose of this testing is used to test the entire system to check if it is working correctly or not.
  • The testing team will do this system testing.
  • If the data warehouse is very large and minimal testing can be completed before creating the test plan.

Data Warehouse Testing Schedule

The test schedule is the process of creating in developing the test plan. In this schedule, it will create an entire test plan estimation required for the data warehouse. There are various methodologies available to create the test plan, but it is very complex to make a plan for the data warehouse. There are some issues faced with creating the schedule.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,527 ratings)
  • Some of the queries taking a long time like a day or two to complete and retrieve the result.
  • Sometimes the hardware may failures E.g., Disk error, connection issue, Disk loss.
  • Causing human errors like deleting the tables, wrong data updation, etc.

Due to these above challenges, recommended increasing double the time to allow for testing.

Testing Backup Recovery

Testing the disaster recovery system is the most important strategy. Below are a few testing scenarios for backup recovery.

  • Loss or Damage of tables.
  • Failure of Media files.
  • Loss or damage to control files.
  • Loss or Damage of redo files.
  • Loss or Damage of Archive files.
  • Loss or Damage of data files.
  • Loss or Damage of table space.

Data Warehouse Testing Operational Environment

When comes to the environment, there are many sources to test such as which are explained below:

Data Warehouse Testing Operational Environment

1. Security

It requires a separate document to test the disallowed operations and how it can be tested in each module.

2. Scheduler

Scheduling software is managing the daily operation which runs automatically with the given period of time. It has an interface between the software and the data warehouse. In the testing process, it will check the processing of being managing the operations.

3. Disk Configuration

Disk configuration needs to check the Input / Output operations of data. Ii has to validate multiple times to check the different conditions of control.

4. Management Tools

It will test all the management items in the system such as.

  • System Manager
  • Event Manager
  • Configuration Manager
  • Database Manager
  • Backup and recovery manager

Data Warehouse Testing Database

Testing the database related item is for storage and retrieving validation which are as follows:

1. Testing the Database Manager

Testing the database manager is to validate the creation, running and managing the query operations

2. Testing the Monitoring Tools

It will monitor the entire operations takes place by the system [E.g., If an event triggered to the system, it will monitor and store somewhere in the log file]

3. Testing the Database Features

Here some of the features which need to be tested.

  • How the query works parallel.
  • How the index can be creating parallel.
  • How the data can be load in parallel.

4. Testing the Database Performance

The most important thing is to measure the performance while executing the complex query in the data warehouse and it has to be normalized. During testing to check the query execute from multiple users and endpoints to meets the business requirements.

Testing the Application

The application testing is the final level of the method to test in the GUI mode and it needs to perform below:

  • Have to check each function is working correctly.
  • Check the application over a period of time.
  • Testing the beginning and end of each weekly / monthly tasks.
  • To ensure all the managers are integrated correctly and in order to load the queries to meet the expectations.

Logistic of Testing

Finally, we also need to test some logistic functions in the system such as,

  • Backup and recovery functions
  • Performance of the query
  • Schedule manager
  • Monitoring data’s
  • Day-to-Day operational methods
  • Scheduling software’s

Recommended Articles

This is a guide to Data Warehouse Testing. Here we discuss the introduction and testing methodology of data warehouse testing along with its detailed explanation. You may also look at the following articles to learn more –

  1. Data Warehouse Design
  2. What is Data Mart?
  3. What is a Data Scientist?
  4. Types of Data Warehouse
Popular Course in this category
All in One Data Science Bundle (360+ Courses, 50+ projects)
  360+ Online Courses |  1500+ Hours |  Verifiable Certificates |  Lifetime Access
4.7
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more