Rapid Battle Cards 11–20
11 — Attribute vs Domain
- Attribute: property that identifies/describes/measures.
- Domain: complete valid value set/structure for that attribute.
- Clue: property vs allowed values.
12 — Relational vs Dimensional
- Relational: operational business-rule representation; normalized integrity.
- Dimensional: analytics/navigation around measured processes.
- Clue: transaction/business-rule accuracy vs analytical questions.
13 — Fact Table vs Dimension Table
- Fact: measurement rows.
- Dimension: descriptive query/report context.
- Clue: measure vs “by what?”
14 — Grain vs Fact
- Grain: what one fact row means.
- Fact: the measurement structure/content.
- Clue: row semantic level vs measured value.
15 — SCD Type 1 vs 2 vs 3
- Type 1: overwrite.
- Type 2: new row/version.
- Type 3: new column for limited previous state.
- Clue: ORC = Overwrite / Row / Column.
16 — Conformed Dimension vs Conformed Fact
- Conformed dimension: shared consistent descriptive context.
- Conformed fact: shared standardized measure definition.
- Clue: shared context vs shared measurement meaning.
17 — Star vs Snowflake
- Star: dimensions comparatively collapsed.
- Snowflake: dimension hierarchies normalized into related tables.
- Clue: collapsed vs normalized dimensions.
18 — Relational vs Object-Oriented
- Relational: data + relationships/keys/business rules.
- OO/UML: classes with attributes plus operations/methods and encapsulation.
- Clue: methods/operations indicate OO.
19 — Fact-Based vs Attribute-Based Modeling
- Fact-Based: objects, facts, roles, controlled verbalization; attributes are not the primary construct.
- Clue: natural-language fact/role modeling.
20 — Data Vault Hub vs Link vs Satellite
- Hub: primary business concept/key.
- Link: relationship/integration among hubs.
- Satellite: descriptive context/history.
- Clue: concept vs relationship vs descriptive history.
Source anchors: current Battle Cards, cards 11–20.