Series: Subject: Topic:
Question: 59 of 135

what is the difference between Datawarehouse and Datawarehousing

Asked by: Interview Candidate | Asked on: Sep 29th, 2006
Showing Answers 1 - 3 of 3 Answers

Answered On : Sep 29th, 2006

View all answers by opbang

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

Login to rate this answer.

Answered On : Dec 30th, 2006

dataware house is a container to  store the historical datawhere as dataware hosuning is a process or technique  to analyze tha data in the ware house

Login to rate this answer.
Rahul Kumar

Answered On : 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

Login to rate this answer.

Give your answer:

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

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.