ETL Testing – Part 3

System Testing: This environment integrates the various components and runs as a single unit. This should include sequences of events that enable those different components to run as a single unit and validate the data flow. Verify all the required functionality in the validation environment. Run end-to-end system test. Record initialization and incremental load statistics….

Read More

ETL Testing – Part 2

Test Estimation: Effective software project estimation is one of the most challenging and important activities in the testing activities. However, it is the most essential part of a proper project planning and control. Under-estimating a project leads to under-staffing it, running the risk of low quality deliverables and resulting in loss of credibility as deadlines…

Read More

ETL Testing – Part 1

ETL Testing: Testing is an important phase in the project life-cycle. A structured well defined testing methodology involving comprehensive unit testing and system testing not only ensures smooth transition to the production environment but also a system without defects. The testing phase can be broadly classified into the following categories: Integration Testing System Testing Regression…

Read More

Data Warehouse & ETL Tutorial

Data Warehouse & ETL Tutorial: Data Warehouse is where data from different source systems are integrated, processed and stored. Data Warehouse data is a non-production data which is mainly used for analyzing and reporting purposes. Business users and higher management authorities use the data warehouse data to analyze, and to make important business decisions. Data…

Read More

ETL Concepts

ETL Concepts: Extraction, transformation, and loading. ETL refers to the methods involved in accessing and manipulating source data and loading it into target database. The first step in ETL process is mapping the data between source systems and target database(data warehouse or data mart). The second step is cleansing of source data in staging area….

Read More

ETL Tools – What to Learn?

ETL Tools: What to Learn? With the help of ETL tools, we can create powerful target Data Warehouses without much difficulty. Following are the various options that we have to know and learn in order to use ETL tools. Software: How to install ETL tool on server/client? Working with an ETL Tool: How to work…

Read More

ETL Tools

What are ETL Tools? ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL code created by programmers. This task was tedious and cumbersome in many cases since it involved many…

Read More
error: Content is protected !!