C4 (2 points)
https://knobit.org/id/task/dm-design-schemes/C4
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/C4 |
| rdfs:label | C4 (2 points) en |
| schema:hasPart | dm-design-schemes C4: view over partitioned balance history |
| schema:identifier | C4 |
| schema:position | 4 |
| schema:text | Views over physical structure, 1 each: (a) a view presenting current account balances with business names (account number, ledger and available balance, currency, balance date) defined over the parent table ab_hist joined to dim_account, current rows only, with the technical columns (ld_btch_id, src_sys_cd, the keys) not exposed; (b) the twelve reports are re-pointed from the partition names to the view, so the January move to daily partitions changes the table and not the reports - no partition name appears in the view. en |
Used by
| has question | Seven retail banking designs in seven DMBOK2 modelling schemes (scheme design skills) |
|---|---|
| schema:isPartOf | dm-design-schemes C4: view over partitioned balance history |