GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Data Warehousing

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



July 07, 2007 08:06:09 #2
 ashathiagarajan   Member Since: February 2007    Total Comments: 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. 
     

 

Back To Question