O'Reilly logo
  • Bruno Antonio thinks this is interesting:

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


Cover of The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition


Como é que isto funciona mesmo?
Percebo o problema mas as resoluç~ies são confusas.