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?
Total Answers and Comments: 19
Last Update: September 11, 2007 Asked by: s.Narasimma subramanian
RE: what is the difference between database and data w...
Major difference is the historical data which can be maintained in data warehouse instead of keeping it in your real time OLTP(database) system.Also we don't want to decrease the processing time of our oltp server for taking data for reporting and analysis purpose.Now why informatica and why other OLAP tools are required :coz companies don't want to spend lots of money in hiring fulltime database developer to write pl/sql packages and procedure to store all these information in ODS.Therefore,most of the time they hire a short-period informatica/ETL developer to make mapping which is GUI based,easy to maintain and easy to run.
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.
