Stack Overflow
Stack Overflow

Questions tagged [fact-table]

fact table mainly consists of business facts and foreign keys that refer to primary keys in the dimension tables

138 questions
190
votes
11 answers

Difference between Fact table and Dimension table?

What is the difference between fact tables and dimension tables? An example could be very helpful.
user2467545
23
votes
3 answers

Design of a data warehouse with more than one fact tables

I'm new to data warehousing. First, I want to precise than my copy of The Data Warehouse Toolkit is on it's way to my mailbox (snail mail :P). But I'm already studying all this stuff with what I find on the net. What I don't find on the net,…
user327961
  • 2,440
  • 3
  • 22
  • 20
15
votes
4 answers

Why primary key is (not) required on fact table in dimensional modelling?

I have heard a few references that pk is not required on fact table. I believe every single table should have a pk. How could a person understand a row in a fact table if there is no pk and 10+ foreign keys.
BI Dude
  • 1,842
  • 5
  • 37
  • 67
12
votes
1 answer

How to create history fact table?

I have some entities in my Data Warehouse: Person - with attributes personId, dateFrom, dateTo, and others those can be changed, e.g. last name, birth date and so on - slowly changing dimension Document - documentId, number, type Address -…
Argnist
  • 535
  • 1
  • 5
  • 18
7
votes
2 answers

One or multiple fact tables?

I am trying to build a data mart. I have lot of dimensions, and couple of measures - facts. Every measure is connected to all dimensions in term of business. There is the standard approach that there will be one big fact table with all measures.…
John
  • 503
  • 2
  • 10
  • 25
7
votes
5 answers

PostgreSQL: Loading data into Star Schema efficiently

Imagine a table with the following structure on PostgreSQL 9.0: create table raw_fact_table (text varchar(1000)); For the sake of simplification I only mention one text column, in reality it has a dozen. This table has 10 billion rows and each…
David
  • 4,786
  • 11
  • 52
  • 80
5
votes
3 answers

Fact table with multiple facts

I have a dimension (SiteItem) has two important facts: perUserClicks perBrowserClicks however, within this dimension, I have groups of values based on an attribute column (let's call the groups AboveFoldItems, LeftNavItems, OnTheFlyItems, etc.) …
Jeff Meatball Yang
  • 37,839
  • 27
  • 91
  • 125
3
votes
1 answer

How to store data in fact table with multiple products in an order in data warehouse

I am trying to design a dimensional modeling for data warehousing for one of my project(Sales Order). I'm new to this concept. So far, I could understand that the product, customer and date can be stored in the dimension table and the order info…
saran
  • 595
  • 5
  • 17
  • 28
3
votes
2 answers

Natural Key and Fact tables

I'm new on dimensional modelling I believe that you guys can help me in the following doubts. In the production system I have a transaction table, sales table for example.The unique identifier is a primary key called SaleId. Example: My doubt is…
vinomalino
  • 55
  • 1
  • 5
3
votes
1 answer

Storing Historical Data in Separate Fact Tables

I am a newbie when it comes to data warehouse projects and would like to seek the advice of the community here. I need to create a data warehouse from which both historical and current information can be extracted in the most efficient/inexpensive…
Dan
  • 533
  • 2
  • 10
  • 21
2
votes
1 answer

From operational data store to warehouse

I have 3 ODS, so in order to create DWH, do I need a DWH for each ODSs, or the DWH select the tables from any of the ODSs?
Ahmed Algosaibi
  • 31
  • 5
2
votes
2 answers

Warehouse: Store (and count) non-fact records?

How to store records that don't contain any fact? For example, let's say that a shop wants to count how many people have entered inside a store (and that they take info on every person that goes inside the shop). In warehouse, I guess there would be…
ilija veselica
  • 9,414
  • 39
  • 93
  • 147
2
votes
1 answer

Fact table reconciliation or verify

In a data warehouse project how do I verify that my fact table loaded in a data warehouse DB through SSIS ETL load is correct with my staging table so that later I don't have incorrect reporting?
Ramesh
  • 21
  • 5
2
votes
2 answers

Star Schema Design / best practice

I am working with a system, which has 4 databases: Account (Storing bank accounts, transactions, etc) Client (Client related info) Credit (getting rates from 3rd party system) Quality (Further internal calculation) I want to create 4 facts tables,…
Hooman Bahreini
  • 14,480
  • 11
  • 70
  • 137
2
votes
1 answer

Data Warehouse - How to store created_time, created_date, complete_time, complete_date

My task table has 4 columns to store created_time, created_date, completed_time, completed_date. When I convert that table to OLAP, Do I want to store them under Date Time dimension or is it ok to keep them in Fact table. Can someone please…
Gayan
  • 2,845
  • 7
  • 33
  • 60
1
2 3
…
9 10