Subscribe to DMU

Search DMU Library

Categories

ETL

ETL Test Automation Planning for DW

Applying DevOps-style test automation to projects can guarantee a high level of data quality in any business intelligence / analytics initiative. According to a CIO.com article, Gartner Group recently stated that between 70 and 80 percent of business intelligence initiatives are initially

Read More

Foundations of Data Extraction Transform Load (ETL)

Data extraction, transformation, and loading processes enable many activities in information technology projects. Understanding the concepts and practices of ETL is essential for all data and technology professionals Data extract, transform, load (ETL) is a process of copying data from

Read More

Introduction to Data Warehouse Testing

Data warehouse and data integration testing should focus on ETL processes, BI engines, and applications that rely on data from the data warehouse and data marts. There is little that casts doubt on a data warehouse and BI project more quickly than incorrectly reported data. 

Read More

Security Threats in the Data Warehouse Environment

Data warehouse implementations are vulnerable to internal as well as external security threats.  Follow these mitigating steps to reduce the risks. Introduction Security threats exist against your information resources, whether the systems are accessible through the Internet or buried deep

Read More