How to use ETL technology tools ?
ETL warehouse testing is categorized into four distinct betrothals irrespective of etl or technology tools used.
New DW checked and is constructed from scratch. Information input signal is taken from customer demands and new data warehouse and differing information sources is assemble and checked using the aid of ETL tools. In such an undertaking customer is going to have ETL and an existing DW however they're trying to tote new tool so that you can enhance efficiency. In such a job new information is added to an existing DW from distinct sources. Additionally, there may be a state where customer must alter their present company rule or they could incorporate the newest rule.
Report Testing: Report will be the fundamental propose for which DW is assembling as well as the end result of any Data Warehouse. Report should be examined by validating information in the report and computation, layout.
Web Source: http://www.ithubonlinetraining.com/etl-testing-online-training/