Data warehouses - for BI or operational systems data?
Data warehouses do more than just store the data, according to William McKnight.
I don't have a problem with the use of the DW as a source of data for other operational systems. If you consider...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Management/Data Warehousing experts
View all Data Management/Data Warehousing questions and answers
Start the conversation
0 comments