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.
Dig Deeper on Data warehouse project management
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.