This Slowly Changing Dimension Quiz asks which type to use when a customer moves from Denver to Austin and sales before the move must stay under Denver. The answer is Type 2. A tested script runs Type 1 and Type 2 side by side, checks the move date and shows both reports.
Watermarks for Incremental Extracts
Watermarks for incremental extracts need clear boundaries, durable checkpoints, and a plan for late updates, deletes, and missed rows.
SSIS Project and Package Deployment Explained
Understand SSIS deployment models, catalog environments, parameter bindings, and the checks that keep package execution predictable after deployment.
Handling the Row That Arrives Late
Handle late arriving data with explicit event dates, inferred dimension members, replay windows, and a clear policy for correcting published history.
Where a Business Rule Should Actually Live
Place the business rules database applications depend on in constraints, procedures, triggers, or application code according to their guarantees.
SSAS Tabular vs Multidimensional: Choosing for a New Project
Compare Tabular vs Multidimensional for SSAS projects, including storage, relationships, write-back, team skills, and model checks.
Surrogate Keys and Natural Keys
Surrogate keys keep warehouse history stable while natural keys preserve source identity; learn lookup, uniqueness, and change handling.