Data Warehousing - What is the use of data warehousing? Can we perform all the transformations using Oracle?

GeekInterview.com > Tech FAQs > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 2 of 45

What is the use of data warehousing? Can we perform all the transformations using Oracle?

Total Answers and Comments: 4

Last Update: April 30, 2008 Asked by: praveenkumar

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 26, 2007 05:07:21

rajeshmavuloori

Member Since: July 2007 Contribution: 3

RE: What is the use of data warehousing? Can we perfor...

Datawarehousing:-

The use of datawarehousing is subject-oriented,historical,timely varient ,integrated collection of data is called datawarehousing.
with the help of this one u can do analysis and generate reports based on DW data.

Transformations:-

it is one of the ETL tool.
Transformation means convert data into based on business rules then load in the datawarehousing.

Is this answer useful? Yes | No

July 30, 2007 08:06:09

ashathiagarajan

Member Since: February 2007 Contribution: 1

RE: What is the use of data warehousing? Can we perfor...

Data warehousing is used to store large amount of data from different databases.The source data we collect may be in different format.So, we transform them to the data warehouse format using ETL tools.From the data warehouse the datas can be retrieved using SQL or like some other query tools and we can generate reports.

Is this answer useful? Yes | No

September 03, 2007 03:38:23

prudhvi.g

RE: What is the use of data warehousing? Can we perfor...

Datawarehousing is nothing but analysing the data and providing solutions to the business people.

Major usage of datawarehousing is that it can analyse the data and stored the data which is historical.

Is this answer useful? Yes | No

April 30, 2008 09:03:35

rmanikandan

Member Since: April 2008 Contribution: 1

RE: What is the use of data warehousing? Can we perform all the transformations using Oracle?

Data warehousing is used to perform Historical records & providing all information by client users. Yes we can persom all the transformatioin usring oracle

Is this answer useful? Yes | No

Go To Top