I am confused in some questions. I need their answers. If our relational model is also De-normalize then why we prefer dimensional model ? What is the reason we prefer dimensional model over relati...

What is the exact difference between fact-less fact and fact table ? I have perused couple of articles but they weren't cogent

I am creating data warehouse model on numerous OLTP tables. a) I can either utilize a Star schema or b) Flat table model table. Many people think dimensional star schema model table is not require...

I'm new to dimensional data modeling and wondering how I can apply it to something that doesn't look like a sales report. Let's say I have a web messenger. It tracks user's device, browser type an...

I am trying to create dimensional model on a flat OLTP tables (not in 3NF). There are people who are thinking dimensional model table is not required because most of the data for the report prese...

I have a DimPlace dimension that has the name of the place (manually entered by the user) and the latitude and longitude of the place (automatically captured). Since the Places are entered manually...

I am from SQL Datawarehouse world where from a flat feed I generate dimension and fact tables. In general data warehouse projects we divide feed into fact and dimension. Ex: I am completely new...

I have some data which has ValidFrom and ValidTo dates associated with it. In simple terms: MembershipId | ValidFromDate | ValidToDate ========================================== 0001 | 1997-01-01 ...

According to The Data Warehouse Toolkit by Kimball "The grain must be declared before choosing dimensions or facts because every candidate dimension or fact must be consistent with the grain." ...

What is the reason that in measure fields in fact tables (dimensionally modeled data warehouses) NULL values are usually mapped as 0?

I am new to SSDT and I'm following the Analysis Services Tutorial called Multidimensional Modeling (Adventure Works Tutorial). And I'm currently on Lesson 3, on the step Modifying the Customer Dime...

I've been trying to solve an issue, and to date I haven't been able to reach what I'd say is an optimal solution. I have a dimension (Features) which needs to be referenced in 2 other dimensions (A...

I'm working in a situation where we're moving from having a bunch of transactional fact tables to a more complicated picture with aggregates, snapshots, etc. In the past, there were a few cases whe...

In SQL Server 2008+, we'd like to enable tracking of historical changes to a "Customers" table in an operational database. It's a new table and our app controls all writing to the database, so we...

I have a PostgreSQL database containing various education data such school-level test scores and enrollment figures. I need to separate enrollment from test scores because the data is on different ...

I am working on my first dimensional modeling assignment for a Data Warehouse project using Kimball's approach. As I prepare my model and think about physical objects, I wonder what is the recommen...

This isn't exactly what I am doing but I feel this is a good example: Let's say I have a Product dimension table that connects to my ProductSales Fact table. Each row in dimProduct holds all the r...

What's a good approach to data warehouse design if requested reports require summarized information about the same dimensions (and at the same granularity) but the underlying data is stored in sepa...

Is a Star-Schema design essential to a data warehouse? Or can you do data warehousing with another design pattern?