A data warehouse is created by transforming an operational database to a data warehouse. The transformation includes a series of steps of data manipulation, such as extracting, cleaning, aggregating, summarising, combining, altering, appending, etc., all of which are called an Extract-Transform-Load...

Firstly, we should know the different of Databases (Operation DB & Date Warehouse). Operation Database.This database system is used to operate the daily business activities of the company. Thiscan be sales, finance, booking systems or any transaction events which are pivotalto the business. This dat...