Blank-Page Reconstructions & Key
Attempt all 12 without looking at the key line.
1 — Inmon/CIF
Prompt: applications → staging/integration → ODS/DW → marts/analysis.
Key: Applications/Sources → Staging → Integration → enterprise normalized DW → Data Marts → BI/Analysis; ODS beside integration for current/near-current needs. Mark DW historical/non-volatile.
2 — Kimball
Prompt: source → staging → dimensional marts + enterprise integration mechanism.
Key: Sources → Staging Services → Fact Areas/Marts → Access; conformed dimensions shared across fact areas; DW bus/bus matrix coordinates integration.
3 — Five storage/access roles
Prompt: staging / ODS / DW / mart / cube.
Key: prepare / current-integrated / historical-integrated / targeted analytical subset / multidimensional OLAP structure.
4 — Historical vs ongoing + CDC
Key: historical = baseline/backfill; ongoing = recurring refresh. CDC = timestamp, log table, transaction log, message delta, full comparison.
5 — Low-latency accumulation
Key: Trickle = source; Messaging = bus; Streaming = target queue/buffer.
6 — Six activities
Key: Understand Requirements → Define/Maintain Architecture → Develop DW/Marts → Populate → Implement BI Portfolio → Maintain Data Products.
7 — Three development tracks
Key: Data (sources/profile/map/DQ/models/rules) | Technology (integration/storage/orchestration/security/operations) | BI (semantic/presentation/reports/dashboards/analysis). Join at releases.
8 — Mapping → Remediation → Transformation → Population
Key: document source-target/rules → fix defect/root cause → intentionally convert/derive → execute controlled loading including exceptions/audit/monitoring.
9 — Product lifecycle
Key: Backlog → Develop → Pilot/Sandbox → Business+IT Readiness → Production → Monitor/Tune → Backlog; release/configuration management spans environments.
10 — Trust/Metadata chain
Key: Dictionary/Glossary/Metadata = meaning/context → Metadata repository integrates it → Lineage = origin/path → Impact = change consequence → DQ/business validation → trust.
11 — BI categories
Key: Tactical = short-term management; Strategic = long-term goals/trends; Self-service = governed user exploration; Operational Analytics = current/low-latency decision support; OLAP = interactive multidimensional analysis.
12 — Value evidence stack
Key: Usage/adoption + Subject-Area Coverage + Load Support/service reliability + Query/refresh Performance + Satisfaction/trust/usefulness.
Pass rule
You pass a reconstruction only when arrows/roles are correct and you can state what changed fact would move the answer to a neighboring concept.
Source: pp. 361–393.