top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between Data warehouse and Data warehousing?

+3 votes
565 views
What is the difference between Data warehouse and Data warehousing?
posted Jun 26, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Data warehousing encompasses a complete architecture and process, whereas Data warehouse is Data stored in Database in the form of Dimension Tables, Fact Tables, Lookup Tables, Aggregated Fact tables.
Data warehousing 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.

answer Jun 26, 2013 by Shatark Bajpai
...