Skip to main content

Strategies for Testing Data Warehouse Applications

June issue of DM Review magazine has an interesting article on Data Warehouse Testing. This topic has always been up for debate. Traditional testing teams want to test a Data Warehouse like any other transactional systems. Whereas Data Warehouse gurus would always suggest testing the input and output. This article lists seven goals for a successful data warehouse testing, namely;

  • Data completeness. Ensures that all expected data is loaded.
  • Data transformation. Ensures that all data is transformed correctly according to business rules and/or design specifications.
  • Data quality. Ensures that the ETL application correctly rejects, substitutes default values, corrects or ignores and reports invalid data.
  • Performance and scalability. Ensures that data loads and queries perform within expected time frames and that the technical architecture is scalable.
  • Integration testing. Ensures that the ETL process functions well with other upstream and downstream processes.
  • User-acceptance testing. Ensures the solution meets users' current expectations and anticipates their future expectations.
  • Regression testing. Ensures existing functionality remains intact each time a new release of code is completed.
This is an interesting read for those who have struggled to find the right balance while implementing strategies for a data warehouse testing.

Comments

shakar12 said…
Hello,
Palmer Leasing Inc offers one of the largest fleets of Quality Mobile Storage, Transportation and Logistics equipment for rent or lease - ready for your use, without the expense, exposure or hassle of ownership and always at competitive rates.

Popular posts from this blog

Koshish Karne Walon Ki Haar Nahin Hoti …

An inspirational poem from Harivansh Rai Bachchan. Thanks to Vishva for the lyrics


Lehron se Darkar nauka par nahin hoti,
koshish karne walon ki haar nahin hoti

Nanhi cheenti jab daana lekar chalti hai,
chadhti deewaron par,
sau bar phisalti hai.
Man ka vishwas ragon mein saahas bharta hai,
chadhkar girna,
girkar chadhna na akharta hai.

Akhir uski mehnat bekar nahin hoti,
koshish karne walon ki haar nahin hoti.

Dubkiyan sindhu mein gotakhor lagata hai,
ja ja kar khali haath lautkar aata hai
Milte nahi sahaj hi moti gehre paani mein,
badhta dugna utsah isi hairani mein.

Muthi uski khali har bar nahin hoti,
koshish karne walon ki haar nahi hoti.

Asaflta ek chunauti hai,
ise sweekar karo,
kya kami reh gayi,
dekho aur sudhar karo.
Jab tak na safal ho,

neend chain ko tyago tum,
Sangharsh ka maidan chhodkar mat bhago tum.

Kuch kiye bina hi jai jaikar nahin hoti,
koshish karne walon ki haar nahin hoti.


- Harivansh Rai Bacchan

लहरों से डर कर नौका पार नहीं होती ,
कोशिश करने वालों  की हार नहीं होती।

नन्ही चींटी जब दा…

The latest #BigData #Analytics Daily! https://t.co/BDdeMOiHQ2 Thanks to @oriolto @AltheaDelalune @Parker_B_Assoc #bigdata #analytics

The latest #BigData #Analytics Daily! https://t.co/BDdeMOiHQ2 Thanks to @oriolto @AltheaDelalune @Parker_B_Assoc #bigdata #analytics Source: The latest #BigData#Analytics Daily! https://t.co/BDdeMOiHQ2 Thanks to @oriolto@AltheaDelalune@Parker_B_Assoc#bigdata#analytics — Sachin Sinha (@SachinSinha) November 23, 2017November 23, 2017 at 03:12PM
via IFTTT