data warehousing 1

[ph]

<br>
hello everybody,<br>
my question is what are the contribution of data warehousing(dw) to management support system., What is the contribution of dw to decision making.

 

[jnicho02]

Have a look at some of the earlier posts in this forum such as 'Differences between OLAP and Data warehousing concepts?'.<br>
<br>
The short answer could be 'A data warehouse brings all relevant data together into a single source enabling decisions to be based on full information'. i.e. data in previously unconnected systems could be included in the same analyses.

 

[Lehtoant]

Dw provides uniformity and perspective. Separate datamarts and OLAP reporting systems tend to give snapshots of current situation (life cycle of these systems is normally shorter). Decision makers like to compare things over time and between different business units and so on. This also means that methods of information gathering must remain the same in order to get reliable data.<br>
<br>
Al

 

[banurura]

hi everybody i want to now genric error handling procedure for my dataware house dataloading so that i can use it for all databases