Normally, the ETL developers as part of the development effort will do unit ETL testing of the ETL processes. These test include some spot tests and summary tests. A unit ETL test is a test written by the programmer to verify that a relatively small piece of ETL code is doing what it is intended…
ETL is a process of extracting (E), transforming (T) and loading (L) the data into the data warehouse or any other data-centric system. The process involved in developing these ETL processes is time consuming and usually follows the steps below: 1. Understand the Business Requirement 2. Create Technical Specification/ Requirement 3. Generate Mapping Document 4.…
Data has become critical to business. Hence, enterprises are investing time, money and resources in data-centric systems such as data warehouse, MDM, CRM & migration projects. However, all research done by independent agencies indicates that There is such a high failure/delays in implementations of data-centric projects Users still don’t trust data coming from data warehouses There…