| February 02, 2006 02:31:18 |
#2 |
| sanyam mittal |
Member Since: Visitor Total Comments: N/A |
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. |
| |
