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  >  Interview Questions  >  Data Warehousing

 Print  |  
Question:  What is the difference between database and data warehousing?
What is the main advantages of data warehousing
What is mean by data stage
What is the famous tools used for data warehousing?
What is the architecture of data warehouisng model?




October 10, 2006 12:17:14 #10
 jessa abraham Database Expert  Member Since: October 2006    Total Comments: 5 

RE: what is the difference between database and data w...
 

dw is also a database but the purpose is for business analysis.

in general a database is a reservior having operational data needed for daily business and they are ever changing. since the new data is always overwriting the old one there is no way to compare the change in data this is wer a dw comes in picture. dw has historical datas and the current data so comparison becomes very easy for business analysis.

ds is a tool for ETL.

ETL tools: informatica, ds junction, abinitio,ds,cognos, etc

reporting: cognos, bo, etc

     

 

Back To Question