Star Schema 101
This table type stores measurements like amounts, counts, or balances and foreign keys to context.
What is a fact table?
This type of key is system‑generated (often an integer) and has no business meaning.
What is a surrogate key?
In the classic acronym, the ‘T’ stands for this step that reshapes and cleanses data.
What is Transform (or Transformation)?
Comparing record counts between source and target to ensure completeness is called this.
What is a row‑count (or record‑count) reconciliation?
The Scrum event where the team plans the upcoming sprint backlog.
What is Sprint Planning?
Standard story format that ties a role, goal, and benefit.
What is ‘As a , I want so that ’?
This table type provides descriptive attributes such as customer name, product category, or department.
What is a dimension table?
A business‑defined identifier like an employee ID or product SKU is this key type.
What is a natural key?
The ingestion pattern that captures only changes—often using timestamps or logs—is called this.
What is Change Data Capture (CDC)?
A test that confirms required fields are populated and within allowed sets checks these two data qualities.
What are completeness and validity (domain constraints)?
This event inspects the increment and adapts the product backlog based on stakeholder feedback.
What is the Sprint Review?
Clear, testable conditions that determine if a story meets expectations.
What are acceptance criteria?
A star schema keeps joins simple by connecting each dimension to this central table.
What is the fact table (at the center of the star)?
In this SCD type, we overwrite attributes in place, keeping no history.
What is SCD Type 1?
The SQL operation that conditionally updates existing rows and inserts new ones in one shot.
What is MERGE (aka upsert)?
Verifying that totals by dimension match source totals is called this type of test
What is an aggregate/roll‑up reconciliation?
The ceremony focused on process improvements for the next sprint.
What is the Retrospective?
BA artifacts that map business concepts like Customer, Order, and Payment to shared definitions.
What are business glossaries or conceptual data models?
Name the dimension that encodes days, months, and fiscal periods, enabling consistent date rollups.
What is the date (or time) dimension?
This SCD type adds a new row for each change and tracks current vs. historical with effective dates.
What is SCD Type 2?
This staging design keeps raw, system‑of‑record copies (often partitioned by load date) to support restatements and auditability.
What is a Persistent Staging Area (PSA) / raw bronze layer?
Flagging values beyond expected statistical ranges (e.g., z‑scores) is this class of testing.
What is anomaly/outlier detection?
Checklist that a story must meet before the team agrees it’s ready to pull.
What is the Definition of Ready (DoR)?
Splitting a large requirement into independently valuable vertical slices is called this.
What is story slicing (vertical slicing)?
When a single dimension plays multiple roles, like Order Date vs. Ship Date, we call it this.
What is a role‑playing dimension?
This SCD approach stores both an overwritten attribute and a historical attribute.
What is SCD Type 3?
Name one common pattern to guarantee task order and dependency handling across multiple jobs.
What is a DAG (directed acyclic graph) / workflow orchestration?
Generating random inputs and asserting invariant rules (e.g., surrogate keys are unique) is known as this.
What is property‑based testing?
The agreement that defines quality bars like tests passing, docs updated, and code merged.
What is the Definition of Done (DoD)?
Formal, machine‑checkable expectations on data shape and semantics between producers and consumers.
What are data contracts (schema + semantics + SLAs)?