Originally posted by kris123
Thanks kuya mike,

I started reading oracle docs about DW and i got questions i cant find answer to like...
What are the requirements for an application to be candidate for Data Warehousing? Do all types all applications need a Data Warehouse? Is it only for applications with large database?


Thanks again.....
There's no particular type or size ... the need for a DWh is generally driven by business requirements for rapid access to current and historical data. In particular it can be very difficult to get trending reports out of OLTP systems (eg. show me the historical trend on the number of customers uninvoiced for more than 30 days).


I shall also humbly suggest a series of articles ... http://www.dbasupport.com/oracle/ora...ousing01.shtml