Q
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.

William McKnight
McKnight Consulting Group
Follow:
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.

This was last published in January 2003

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.

You will be able to add details on the next page.

Meet all of our Data Management/Data Warehousing experts

View all Data Management/Data Warehousing questions and answers

Start the conversation

Send me notifications when other members comment.

Register

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close