C1 (2 points)
https://knobit.org/id/task/dm-design-schemes/C1
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dm-design-schemes/C1 |
| rdfs:label | C1 (2 points) en |
| schema:hasPart | dm-design-schemes C1: star schema for card authorisations |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | Star schema for a stated grain, 1 each: (a) the fact is at one row per approved authorisation (auth_id as a degenerate dimension), its additive measures are billing_amount_eur and interchange_fee_eur at that grain, the transaction-currency amount is not treated as additive across currencies, and the dimension keys are date, card, merchant and account - with dim_date and dim_account the bank's existing conformed dimensions, reused rather than redesigned; (b) nothing at a coarser grain sits in the fact: the monthly card fee (card-month) is kept out - its own fact, or excluded with the reason - and declined authorisations are outside the grain. en |
Used by
| has question | Seven retail banking designs in seven DMBOK2 modelling schemes (scheme design skills) |
|---|---|
| schema:isPartOf | dm-design-schemes C1: star schema for card authorisations |