Rather than altering the declared grain to be something unnatural such as one row per payment method per product on a POS transaction, you would likely capture the payment method in a separate fact table with a granularity of either one row per transaction (then the various payment method options would appear as separate facts) or one row per payment method per transaction (which would require a separate payment method dimension to associate with each row).
- Chapter 3: Retail Sales
- from The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
- Publisher: John Wiley & Sons
- Released: July 2013
Como é que isto funciona mesmo? Percebo o problema mas as resoluç~ies são confusas.
Share this highlighthttp://www.safaribooksonline.com/a/the-data-warehouse/4779552/