Problem solve
Get help with specific problems with your technologies, process and projects.
Data warehouses - for BI or operational systems data?
Data warehouses do more than just store the data, according to William McKnight.
How do you explain to users when requests from the user transform the data warehouse from being a repository of business intelligence and such information.... into a source of data for other operational systems?
I don't have a problem with the use of the DW as a source of data for other operational systems. If you consider that the data warehouse is where the data will be cleansed, it is the logical place to get data for operational systems. This is the so-called "closing the loop" with data warehousing. In terms of additional DW usage, in whatever form that takes on, the only thing to be wary of is impact on other DW usage (and load cycles, etc.). As long as that is considered, I don't see a problem with the transformation you speak of.
Start the conversation
0 comments