Recognises a fact table of mixed grain
https://knobit.org/id/knobit/K-626
Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium
| Context functions | Result evaluation |
|---|---|
| Knobit creation methods | AI generated, human edited |
| Knobit types | Skill |
| LCG purposes | Assessing the learner's knowledge or skill state |
| LCG purposes | Selecting an assessment task or learning activity |
| action verb | Recognises en |
| applies knowledge | Explains grain and additivity in dimensional models |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: `fact_account_balance` with one row per payment carrying `ledger_balance_amount`, which is per account per day: an account with three payments in a day reports three times its balance Acceptable: A grain sentence, and every column true at that grain; `fact_payment` at payment grain and daily balances on `fact_account_balance_daily` (`PHY-013`, `PHY-028`) en |
| assessment method | skill-tests task: Loan application physical model on Snowflake (physical design anomaly skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-626 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 04-physical, row 26; C&B ("Data Warehousing Design": choosing the grain); E&N 29.3; S&W 16.6 en |
| expected result | The grains mixed and the measures double counted en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/06-physical/26 |
| rdfs:label | Recognises a fact table of mixed grain en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Mixed grain (physical model) en |
| skos:definition | A fact or wide table whose rows mean different things, or whose columns are true at different grains. Measures at the coarser grain repeat on every finer row and are counted again when summed. en |
| skos:prefLabel | Recognises a fact table of mixed grain en |
| target object | fact or wide table en |
Used by
| includes knobit | Designs a physical data model for the target platform without introducing anomalies |
|---|---|
| requires knobit | Design the physical data model |