Are there any tradeoffs between stability versus flexibility during data warehouse design?
Is there any documentation that shows this? Another question: I wonder now how master data management fits in an SOA implementation and in data warehousing? What’s the relation between these three technologies? Joe Oates’ Answer: I am not sure what you mean in the first part of your question regarding the difference between stability and flexibility. About the closest one can come to a standard industry methodology is the Ralph Kimball approach. I recommend that you read his seminal work on introduction to data warehousing. This book is entitled The Data Warehouse Toolkit (Second Edition). There are other books by Kimball that delve deeper into the data warehouse lifecycle, ETL and dealing with Web applications. I suggest that you read this series of books. As to the second part of your question, let’s start with simple definitions. Master data management (MDM) is an approach to provide “a single version of the truth” for data categories, such as customer, product, etc., that span appl
