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
1
vote
2 answers

Identifying percentage in Fact Table

I am new in programming and could not find an answer. I have following dimensions(tables) and fact table: Customer: CustomerId, HomeRegion Regions: RegionId, RegionName MyTime: id, MyHour Fact table: CustomerId, RegionId, TimeId, FactId I must…
Ulugbek
  • 141
  • 11
1
vote
1 answer

Modeling Datawarehouse: Alter table or 2 fact table?

I'm actually modeling a datawarehouse In one of my fact table I have 3 data (number that I want to analyse). The problem is that I'll first fill in one of the number, and later on (few days) fill in the 2 others numbers. Is it a bad thing to do it…
joris
  • 435
  • 1
  • 7
  • 18
1
vote
1 answer

Loading Fact Tables with SQL Server

I'm creating a warehouse using SQL Server 2008 and Analysis Services. I've managed to create and populate the dimension tables, but I'm having a lot of trouble writing the SQL for loading the fact table. For one thing, I'm not sure how to load the…
Natesh Mayuranathan
  • 21
  • 1
  • 4
0
votes
2 answers

Row Inserted and Updated Time in Fact Table

I see there is an importance in having a row inserted and a row last updated fields in a fact table. But I could not find any standard data warehouse or a reference which says that this is a good thing to do. I am uncertain whether this is because…
picmate 涅
  • 3,951
  • 5
  • 43
  • 52
0
votes
2 answers

How to know if it is a good choice to make a field with only a few distinct possible values as a dimension table?

I am trying to create a fact table and dimension tables from a taxi trips records where I downloaded from https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page. This is the data dictionary describes the meaning of the fields. I am not quite…
shihs
  • 331
  • 3
  • 11
0
votes
1 answer

Hirerachal dimensions

I have two dimensions "Job Family" and "Job Subfamily" linked to a fact table. I didn't make a relationship between them even tho they sound related. I didn't make a relationship to make my model optimal since if I did, the JobSubfamily would be the…
userrr
  • 197
  • 7
0
votes
3 answers

Reporting Queries: Best Way to Join Multiple Fact Tables?

I'm working on a reporting system that allows the user to arbitrarily query a set of fact tables, constraining on multiple dimension tables for each fact table. I've written a query-builder class that automatically assembles all the correct joins…
benjismith
  • 16,559
  • 9
  • 57
  • 80
0
votes
2 answers

Fact Table and Grain - Repeating Measures?

Suppose I have tables as indicated below. I'm trying to create correct fact tables. If I combine both tables into one fact table, I would be repeating the sales measure since each sale contains at least two items (admin fee, cleaning and so on -…
Fisk
  • 227
  • 1
  • 12
0
votes
2 answers

How to handle repeating values in fact table due to few numeric columns being at a higher grain?

I am looking at a fact table which has a certain grain. So each record represents a transaction at that grain. Let's say the grain is header detail sub-detail. But there are some numeric columns in this table that have values of a higher grain. That…
variable
  • 8,262
  • 9
  • 95
  • 215
0
votes
0 answers

Why does my Fact Table show NULL for all Foreign Key values, instead of the corresponding Dimension Table Values?

I'm trying to build a Star Schema in MySQL. I have the raw data, and I've uild the Dimension Tales and Fact Table. But it looks like my Fact Table is linking correctly to the Dimension Table, because all the Foreign Key values are NULL. How do I…
HotBrown1es
  • 1
  • 2
0
votes
0 answers

get a slicer to show correctly data from dim table when flittering from a fact table

I have fact table of tickets. There is a field in that table called ownerSK which has the owner of the ticket. This is in the form of there email address. There is also a dim table called Employee which has ownerSK and EmployeeName. This table is…
Adrian lock
  • 3
  • 9
0
votes
0 answers

Design Challenge Fact & Dimension

I am going to create one Fact table which is actually at transactional grain. In table we have only text fields ,no numeric measure & 22 fields of this table actually referencing one lookup table in Relational Database. For example Patient first…
Nit
  • 1
  • 1
0
votes
1 answer

Is this the correct way to have multiple fact table?

Currently, i am in the process of designing a schema for storing product information which in the end will be used for analyzing the price changes, availability of the product itself. The granularity of the analysis can varied, whether its on item…
Rafael Aditama
  • 15
  • 4
0
votes
1 answer

Populate Dim and Fact Table from Source Table which already has a Natural Key

I have a Source Table which looks like as below (pls focus on the show_id column) [ And below is the Dim and Fact Table Diagram from my school's guide: They put the show_id from the Source Table directly inside the Fact table, which confuses me. I…
Hoang Minh Quang FX15045
  • 733
  • 1
  • 4
  • 15
0
votes
0 answers

Populate Periodic Snapshot Fact Table

dim_order dim_date orders facthistorylevel examplei want to populate data into facthistorylevel table as example bút i dont know how to do it with mysql. anyone help me
dũng nguyễn
  • 1
1 2 3
…
9 10