question

HAD avatar image
HAD asked

Data Warehouse as source to application?

There has been some debate on whether it makes sense for an application to source its data from the datawarehouse. The application would still stage the data but it would get it from the datawarehouse. The argument for is that all the logic is already built into the datawarehouse. This makes a lot of sense to me not only from a workload perspective but also consistency on how the calculations are made i.e. if rebuilt the two systems may not stay in sync, reporting different data. The argument against is that this creates a dependency for the datawarehouse to manage a system that fits the needs of the application in addition to its current requirements. Any thoughts on the subject? How have you previously handled this scenario?
sql serverdatawarehouse
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.