Data Warehouse Testing - Data Quality Validation Approaches
Data Validation Testing
1. Black Box Testing
Black box data testing validates data based on expected results. The following aspects require verification:
Table schema alignment with design specifications
Primary key uniqueness constraints
NOT NULL field valiadtions
Invalid input handling
Enumerated value accuracy
Negative value checks for mone ...
Posted on Sun, 24 May 2026 19:21:29 +0000 by deansatch
Building an E-commerce Data Warehouse with Kettle and MySQL
Business Overview
A small online retailer wants daily insight into sales performance—order volume, revenue, and payment-method splits. The operational system (MySQL schema itcast_shop) contains six transactional tables that must be moved into a dedicated analytics store (itcast_shop_bi) and then aggregated for reporting.
Operational Schema
T ...
Posted on Tue, 19 May 2026 03:36:23 +0000 by icd_lx
Hive Fundamentals for Data Warehousing
Introduction to Hive
Hive is an open-source data warehouse system built on top of Hadoop. It enables the mapping of structured and semi-structured data files stored in HDFS in to database tables, providing a SQL-like language called HiveQL (HQL) for querying and analyzing large datasets. Hive's core functionality is to translate HiveQL queries ...
Posted on Thu, 14 May 2026 14:36:14 +0000 by willpower