It's always helpful to have someone with keen knowledge of the source system realities involved. You might also include some physical DBA and ETL team representatives so they can learn from the insights uncovered during the modeling effort and resist the temptations to apply third normal form (3NF) concepts or defer complexities to the BI applications in an effort to streamline the ETL processing. Remember the goal is to trade off ETL processing complexity for simplicity and predictability at the BI presentation layer.
- Chapter 18: Dimensional Modeling Process and Tasks
- from The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
- Publisher: John Wiley & Sons
- Released: July 2013
I like this paragraph
Share this highlighthttp://learning.oreilly.com/a/the-data-warehouse/17746/