<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v" -->

---
title: 20 Data Warehouse Terms You MUST Know Before Your Interview
description: A data engineer with nearly four years of experience at Nordia shares 20 data warehousing and data modeling terms commonly asked about in technical interviews...
canonical: https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: 20 Data Warehouse Terms You MUST Know Before Your Interview | daily.dev
og:description: A data engineer with nearly four years of experience at Nordia shares 20 data warehousing and data modeling terms commonly asked about in technical interviews...
og:url: https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v
og:image: https://api.daily.dev/og/posts/PvAlxa69v.png
og:image:alt: 20 Data Warehouse Terms You MUST Know Before Your Interview
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# 20 Data Warehouse Terms You MUST Know Before Your Interview

**[techTFQ](https://daily.dev/sources/techtfq)** · 10 min read · 2 upvotes · 0 comments

## Summary

A data engineer with nearly four years of experience at Nordia shares 20 data warehousing and data modeling terms commonly asked about in technical interviews for data engineering, BI, and data analyst roles. Topics covered include database vs. data warehouse, OLTP vs. OLAP, data marts, data lakes vs. lakehouses, conceptual/logical/physical modeling, ER diagrams, table relationships, Kimball vs. Inmon methodologies, fact vs. dimension tables, star vs. snowflake schemas, grain, fact table types, conformed dimensions, role-playing dimensions, primary vs. foreign keys, surrogate vs. natural keys, referential integrity, normalization vs. denormalization, and slowly changing dimensions. The video promotes a free downloadable PDF and the creator's paid courses for deeper coverage.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.youtube.com/watch?v=LYKoOSmSEPg>

## Questions this post answers

### What is the difference between a star schema and a snowflake schema?

A star schema has one central fact table connected directly to fully denormalized dimension tables, making it simple and fast to query. A snowflake schema breaks those dimension tables down further into related subtables that are normalized to save space, at the cost of more complex joins. Star schemas trade storage efficiency for query simplicity, while snowflake schemas do the opposite.

_Comparing schema designs before a project kickoff gets easier with warehousing explainers surfaced on daily.dev._

### What are the three types of slowly changing dimensions (SCD) in data warehousing?

Type one overrides the old value and loses history, type two adds a brand new row to preserve full history, and type three adds a new column to track just the previous value. Type two is the most commonly used approach and the one interviewers dig into most, because implementing it correctly is genuinely tricky.

_Interview prep on tricky data modeling concepts like this stays organized with daily.dev._

### What is the difference between the Kimball and Inmon approaches to data warehouse design?

Kimball builds bottom-up, starting with specific business needs and using dimensional modeling to get value fast, trading some consistency for speed. Inmon builds top-down, creating one normalized enterprise warehouse first and then deriving department-specific data marts from it, trading speed for long-term integration.

_Weighing architecture philosophies like Kimball versus Inmon is easier with references on daily.dev._

## Similar posts on daily.dev

- [Data Modeling for Analytics Engineers: The Complete Primer](https://daily.dev/posts/data-modeling-for-analytics-engineers-the-complete-primer-8nszidmhk) · Towards Data Science · 1 upvotes · 0 comments
- [Master Fact vs Dimension in Data Warehouse: A Checklist for Data Engineers](https://daily.dev/posts/master-fact-vs-dimension-in-data-warehouse-a-checklist-for-data-engineers-m5hufscpz) · Decube · 0 upvotes · 0 comments
- [Master Fact and Dimension in Data Warehouse: Key Concepts and Practices](https://daily.dev/posts/master-fact-and-dimension-in-data-warehouse-key-concepts-and-practices-mnr7oo3x6) · Decube · 0 upvotes · 0 comments

---

Tags: [#sql](https://daily.dev/tags/sql), [#interview](https://daily.dev/tags/interview), [#data-warehouse](https://daily.dev/tags/data-warehouse)

[View this post on daily.dev](https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"20 Data Warehouse Terms You MUST Know Before Your Interview","url":"https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v"},"datePublished":"2026-09-15T14:27:39.711Z","dateModified":"2026-09-15T14:27:59.033Z","description":"A data engineer with nearly four years of experience at Nordia shares 20 data warehousing and data modeling terms commonly asked about in technical interviews...","image":"https://i.ytimg.com/vi/LYKoOSmSEPg/sddefault.jpg","thumbnailUrl":"https://i.ytimg.com/vi/LYKoOSmSEPg/sddefault.jpg","isAccessibleForFree":true,"articleSection":"techTFQ","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"techTFQ","logo":"https://media.daily.dev/image/upload/s--dgjhXj89--/f_auto,q_auto/v1780213385/logos/techtfq?_a=BAMAMiWQ0","url":"https://daily.dev/sources/techtfq"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":2},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"sql,interview,data-warehouse","timeRequired":"PT10M","video":{"@type":"VideoObject","name":"20 Data Warehouse Terms You MUST Know Before Your Interview","description":"A data engineer with nearly four years of experience at Nordia shares 20 data warehousing and data modeling terms commonly asked about in technical interviews...","thumbnailUrl":"https://i.ytimg.com/vi/LYKoOSmSEPg/sddefault.jpg","uploadDate":"2026-09-15T14:27:39.711Z","duration":"PT10M","url":"https://api.daily.dev/r/PvAlxa69v","embedUrl":"https://www.youtube.com/embed/LYKoOSmSEPg"}}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"techTFQ","item":"https://daily.dev/sources/techtfq"},{"@type":"ListItem","position":3,"name":"20 Data Warehouse Terms You MUST Know Before Your Interview"}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/20-data-warehouse-terms-you-must-know-before-your-interview-pvalxa69v#faq","mainEntity":[{"@type":"Question","name":"What is the difference between a star schema and a snowflake schema?","acceptedAnswer":{"@type":"Answer","text":"A star schema has one central fact table connected directly to fully denormalized dimension tables, making it simple and fast to query. A snowflake schema breaks those dimension tables down further into related subtables that are normalized to save space, at the cost of more complex joins. Star schemas trade storage efficiency for query simplicity, while snowflake schemas do the opposite. Comparing schema designs before a project kickoff gets easier with warehousing explainers surfaced on daily.dev."}},{"@type":"Question","name":"What are the three types of slowly changing dimensions (SCD) in data warehousing?","acceptedAnswer":{"@type":"Answer","text":"Type one overrides the old value and loses history, type two adds a brand new row to preserve full history, and type three adds a new column to track just the previous value. Type two is the most commonly used approach and the one interviewers dig into most, because implementing it correctly is genuinely tricky. Interview prep on tricky data modeling concepts like this stays organized with daily.dev."}},{"@type":"Question","name":"What is the difference between the Kimball and Inmon approaches to data warehouse design?","acceptedAnswer":{"@type":"Answer","text":"Kimball builds bottom-up, starting with specific business needs and using dimensional modeling to get value fast, trading some consistency for speed. Inmon builds top-down, creating one normalized enterprise warehouse first and then deriving department-specific data marts from it, trading speed for long-term integration. Weighing architecture philosophies like Kimball versus Inmon is easier with references on daily.dev."}}]}
```

