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

  • Interview Candidate
  • 12
  • 3689

Showing Answers 1 - 12 of 12 Answers

rajeshmavuloori

  • Jul 26th, 2007
 

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.






  Was this answer useful?  Yes

ashathiagarajan

  • Jul 30th, 2007
 

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. 

  Was this answer useful?  Yes

prudhvi.g

  • Sep 3rd, 2007
 

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.

  Was this answer useful?  Yes

rmanikandan

  • Apr 30th, 2008
 

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

  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.

 

Related Answered Questions

 

Related Open Questions