1 / 8

Data Warehouse Testing

Automate Data Warehouse to accelerate testing cycles, risks, reduce cost and improve data quality. Request 30 days trial!

nikd123
Download Presentation

Data Warehouse Testing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Warehouse Testing The process of verifying the entire data warehouse landscape for data integrity and data accuracy is called Data Warehouse Testing.

  2. Data Warehouse Testing Challenges • Testing a data warehouse with a high volume of Data. • Testing a Business Intelligence (BI) Report. • Comparing data across heterogeneous data sources. • The inability to identify data issues on time. • Testing across multiple environments.

  3. Type of Data Warehouse Testing Checks • Source data validation - This test is to ensure that the data in the source table or file does not have any Data Quality or Data Accuracy issues. • Source to target reconciliation - This Data Warehouse test is for Data Completeness between source and target when there is not transformation involved, and it is a one to one load.

  4. Type of Data Warehouse Testing Checks • ETL reconciliation - Testing the Data Warehouse for any Data Transformation, Conversion, or Calculation issues is crucial to ensure Data Completeness.  • Business validation - The purpose is to ensure that data is not breaking any business rules even if the ETL has loaded the table successfully.

  5. Type of Data Warehouse Testing Checks • Business reconciliation - Ensuring that data between two subject areas is consistent and is not breaking any business rule is one of the Data Warehouse testing check users perform.

  6. Five Things to Look For in Data Warehouse Testing Tool Integration High data volume testing Regression testing Reporting Test across data sources

  7. Use iCEDQ for Data Warehouse Testing • Test 100% of the data in your Data Warehouse and identify any data issues using our in-memory engine or the Apache Spark engine.  • Users can connect to different data sources, be it a database, file source, or a reporting tool, and validate and compare data across them. • Create test suites for regression testing, release management testing, or for reusing the same Data Warehouse tests across multiple environments. • Integrate iCEDQ with your test management tool like HP ALM, ticketing systems like JIRA, or CICD tools like Jenkins using our Rest API or CLI utilities.

  8. Request a 30 Day Free Trial

More Related