Top "Data-warehouse" questions

A data warehouse (DW) is a database specifically structured/designed to aid in querying, analyzing and reporting (generating reports out of) of current and historical data.

Naming standards for dimensional modeling

I am working on my first dimensional modeling assignment for a Data Warehouse project using Kimball's approach. As I prepare …

data-warehouse dimensional-modeling
How to handle late arriving dimension and NULL business key in Kimball Data Mart?

I'm trying to implement Kimball data mart which uses -1 and -2 rows in dimension table for late arriving dimension …

sql sql-server database-design data-warehouse dimensional-modeling
Handling nulls in Datawarehouse

I'd like to ask your input on what the best practice is for handling null or empty data values when …

sql ssis ssas data-warehouse
Calendar table for Data Warehouse

For my data warehouse, I am creating a calendar table as follows: SET NOCOUNT ON DROP Table dbo.Calendar GO …

sql-server data-warehouse
Data Warehousing - Star Schema vs Flat Table

I'm trying to design a Data Warehouse for a single store of commonly required data ranging from finance systems, project …

data-warehouse star-schema
Data Warehouse Considerations: When and Why?

A little background here: I know what a data warehouse is, more or less. I've read several dozen guides on …

database database-design data-warehouse
Structure within staging area of data warehouse

We are working on a datawarehouse for a bank and have pretty much followed the standard Kimball model of staging …

sql database-design data-warehouse
What's the Grain in the context of DW

According to The Data Warehouse Toolkit by Kimball "The grain must be declared before choosing dimensions or facts because every …

sql database oracle data-warehouse dimensional-modeling
Good place to start learning data warehousing?

I am interested in learning more about data warehousing. I see terms like "dimension", "snowflake schema" and "star schema" thrown …

resources data-warehouse