What is the difference between Datawarehouse and Datawarehousing

Showing Answers 1 - 4 of 4 Answers


  • Sep 29th, 2006

Data warehousing encompasses a complete architecture and process, whereas Data warehouse is Data stored in Database in the form of Dimension, Fact Tables, Lookup Tables, Aggregated Fact tables.

Datawarehousing is not just having a single data warehouse . Data warehousing is the transformation of data to information, thereby enabling the business to examine its operations and performance. This task is accomplished by the staging and transformation of data from data sources, enabling the business to access and analyze information. The data stores may be persistent (stored on disk) or transient (using disk or memory). In addition, the workflow usually involves multiple data stores to support the staging and transformation of data into information such as operational data stores, data warehouses, data marts, online analytical processing cubes, files such as a flat file (comma-separated values extract, for example), XML data and even spreadsheets

  Was this answer useful?  Yes


  • Dec 30th, 2006

dataware house is a container to  store the historical data

where as dataware hosuning is a process or technique  to analyze tha data in the ware house

  Was this answer useful?  Yes

Rahul Kumar

  • Oct 12th, 2011

Hey Opbang
Ur statement "Datawarehousing is not just having a single data warehouse",
with datawarehousing it is understood that business decision can be taken and lots of information and analysis report we can generate .
So Wat is new in your statement, Before stating anything just clarify yourself and put the statement...

Thanks You, waiting for your reply

  Was this answer useful?  Yes


  • Jan 25th, 2017

Datawarehouse: Datawarehouse is a container consists of Subject-oriented, Time variant, Non-volatile and Integrated collection of data which is a Historical data.
Datawarehousing: Datawarehousing is a process of Designing of DWH/Database, ETL process(Extraction,Transformation,Loading) and Reporting.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions