Tag: dimensional-modeling

Found 23 results for 'dimensional-modeling'.

---

1) mysql - How to optimally structure a table with sparse data
2) database-design - Type 2 Dimension for a fact measure
3) data-warehouse - How to handle NULL Dates in an "Accumulating fact table"
4) database-design - Should I create a Factless Fact Table or Denormalise my table
5) sql-server - Designing a dimensional DB off a normalized source that already implements SCD's
6) mysql - Type of Foreign Keys for a Dimensional Model Fact Table?
7) data-warehouse - Business Logic in Data Warehouse
8) sql-server - Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
9) data-warehouse - Boolean as measure in fact table or dimension/attribute value
10) sql-server - How do I make a nullable "parent" hierarchy level?
11) sql-server-2012 - Ordering of a dimension in sql server datawarehouse
12) dimensional-modeling - In the practice of Kimball's Dimensional data warehouse design model, do lookup tables (not dimensions) contain a sid column?
13) dimensional-modeling - What is the difference between bridge table and helper table in data warehouse's context?
14) data-warehouse - Modeling Conversion Events in a Data Warehouse
15) sql-server - SSAS Hierachies duplicates when browsing
16) database-design - The right way to model multiple FACTs schema
17) postgresql - To normalize or not to normalize for few distinct values
18) dimensional-modeling - Summarizing over Outrigger Dimensions Directly (e.g. Total Customers by Demographic by Signup Date)
19) database-design - Should I use separate address dimensions?
20) data-warehouse - What to do when facts change frequently in a star schema for data warehouse?
21) database-design - Is my understanding of Fact table granularity correct?
22) data-warehouse - Boolean flag in fact table
23) data-warehouse - Deciding what values should be used in a data warehouse dimension?

---