menu
{ "item_title" : "Understanding Etl and Data Warehousing", "item_author" : [" Jaiteg Singh "], "item_description" : "Testing in data warehouse systems is substantial because it is oriented towards the correctness and validation of data/ information supplied for decision making. Keeping in view the idiosyncratic characteristics of data warehouse testing and the complexity of data warehouse projects, this research has reviewed and revised the scope of automated testing in assuring quality data warehouse solutions. Initially a data set generator has been developed to generate synthetic but near to real data; followed by the classification of anomalies in synthesized data with the help of a hand coded Extraction, Transformation and Loading (ETL) routine. To ensure quality data for a data warehouse and to promulgate the importance of Extraction, Transformation and Loading (ETL) routines some test cases of prime importance were identified. Later on automated testing procedures were embedded in hand coded ETL routine to ensure quality data. The statistical analysis revealed major enhancement in data quality with the introduction of automated testing procedures. The various data warehouse architectures have been analyzed to endorse a refined data warehouse architecture named as Data Sharehouse.", "item_img_path" : "https://covers3.booksamillion.com/covers/bam/3/84/339/093/3843390932_b.jpg", "price_data" : { "retail_price" : "85.32", "online_price" : "85.32", "our_price" : "85.32", "club_price" : "85.32", "savings_pct" : "0", "savings_amt" : "0.00", "club_savings_pct" : "0", "club_savings_amt" : "0.00", "discount_pct" : "10", "store_price" : "" } }
Understanding Etl and Data Warehousing|Jaiteg Singh

Understanding Etl and Data Warehousing : Issues, Challenges and Importance

local_shippingShip to Me
In Stock.
FREE Shipping for Club Members help

Overview

Testing in data warehouse systems is substantial because it is oriented towards the correctness and validation of data/ information supplied for decision making. Keeping in view the idiosyncratic characteristics of data warehouse testing and the complexity of data warehouse projects, this research has reviewed and revised the scope of automated testing in assuring quality data warehouse solutions. Initially a data set generator has been developed to generate synthetic but near to real data; followed by the classification of anomalies in synthesized data with the help of a hand coded Extraction, Transformation and Loading (ETL) routine. To ensure quality data for a data warehouse and to promulgate the importance of Extraction, Transformation and Loading (ETL) routines some test cases of prime importance were identified. Later on automated testing procedures were embedded in hand coded ETL routine to ensure quality data. The statistical analysis revealed major enhancement in data quality with the introduction of automated testing procedures. The various data warehouse architectures have been analyzed to endorse a refined data warehouse architecture named as Data Sharehouse.

This item is Non-Returnable

Details

  • ISBN-13: 9783843390934
  • ISBN-10: 3843390932
  • Publisher: LAP Lambert Academic Publishing
  • Publish Date: January 2011
  • Dimensions: 9 x 6 x 0.47 inches
  • Shipping Weight: 0.67 pounds
  • Page Count: 204

Related Categories

You May Also Like...

    1

BAM Customer Reviews