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
0
votes
2 answers

Is Id column required / recommended in fact table in the given scenario

I am using a fact table with the following structure in SQL Server 2012: CREATE TABLE [dbo].[factTable] ( [Id] BIGINT IDENTITY (1, 1) NOT NULL, [Date] DATE NOT NULL, [MinuteNumber] SMALLINT NOT NULL, …
user3446562
  • 3
  • 2
0
votes
1 answer

Fact Table Design Confusion - Calculated Measures and more

I'm quite new to data warehousing and dimensional modelling and I need clarification on a few things. I currently have the following dimensions: DimProducts - Information about a product. DimMaterials - Information about materials that go into a…
Flynn
  • 215
  • 3
  • 5
  • 13
0
votes
1 answer

Data Warehouse how to connect fact table with foreign key to dimension table whose primary key contains two attributes

I want to design my Data Warehouse fact-dimension schema, fact table should have several foreign keys, Aid, Bid, Cid.... refer to dimension tables A, B, C,.... respectively. However, dimension table C has an unique key (Aid, Cid). In this case, is…
lanyou
  • 3
  • 3
0
votes
2 answers

Look up surrogate keys and Populate fact table

I have 8 surrogate keys that I need to lookup on the dimension tables and populate a fact table. I created 8 lookups to the dimension tables, and then use the merge join and sort components to merge the data into one result set for insertion into…
John W. Mnisi
  • 845
  • 2
  • 11
  • 16
0
votes
2 answers

Setting the ID in a fact table from a dimension table

In my dimension table for abandoned calls I have the ID 1 Code NO , ID 2 Code YES I am wanting to load these ID's into the fact table based on whether or not the call was abandoned using a join. How ever the problem I'm having it that the Abandoned…
Richard C
  • 389
  • 2
  • 5
  • 16
0
votes
3 answers

Data warehouse design - how to design fact table?

I'm new in DW and I need to create a very simple warehouse for an e-commerce website. Dimension tables date dimension table (id, year, quarter, month, day) time dimension table (id, hour, minute) product dimension table (id, product name, price,…
jnemecz
  • 3,171
  • 8
  • 41
  • 77
0
votes
1 answer

ssas cube: How is the data being pulled?

If there is single partition for a measure group, aggregation designed 0%, partition table being used as an empty table (a template), how does the cube browser still show data for the measure in that measure group. FYI: The partitions are generally…
sagar
  • 159
  • 3
  • 13
0
votes
1 answer

cube partitions: is the fact table in the DSV designer just one of the cube partitions?

There are 16 partitions for a fact table. All 16 of them have the same structure and have the same aggregation scheme. 15 of them contains data and while the 16th contains no data. So, is the fact table in the DSV designer just one of those…
sagar
  • 159
  • 3
  • 13
0
votes
2 answers

what if a fact table/view is a template(meant to contain only table structure but no data)?

I noticed that the fact tables used in a cube were actually views. Infact they were the templates of the fact tables (i noticed it in the script that "where 1=2" was used for the fact-views). So, if the template is used, there wont be any data in…
sagar
  • 159
  • 3
  • 13
-1
votes
1 answer

Can I include string values in Fact Table?

I have a fact table called Fact_Employee_leave where each row refers to the Leave taken by each employee referencing to (dim_employee) which is starting and ending at a specific date referencing to (dim_date) I designed the fact table as…
userrr
  • 197
  • 7
-1
votes
2 answers

Problem placing attribute in dimensional layout

I am doing a small exercise, I need to create a small dimensional design that deals with the tsunamis that have occurred in different countries over the years. I have created a "Country" dimension and a "Location" dimension. In each record of the…
Luis
  • 65
  • 7
-1
votes
1 answer

One or multiple fact tables for different businesses in one company?

I'm new to database design. I'm trying to design a data model for car sharing company. They have more than one business model like car sharing, scooter sharing, delivery. Here is my dilemma, which choice should I choose: (database warehouse bus…
emfffff
  • 1
  • 1
-1
votes
1 answer

Fact table and Dimension tables

I was learning online how what is fact table and dimension table , so it advised to practiced with real data set. as a sample I downloaded this excel file. I want to try star schema, As far as I under stood it can be divided into multiple fact…
Escaper
  • 69
  • 1
  • 9
-1
votes
3 answers

Joining two fact tables with common dimensions

I get the concept on how to join dimensions to a fact table. However, I am having some difficulties in joining multiple (two) fact tables through common dimension tables. To be specific, I have a fact table with actual sales figures, and a fact…
Thomas Ejlerskov
  • 11
  • 1
  • 1
  • 5
-1
votes
1 answer

multi links between Fact_Table & Date_Dimension

In my Fact_Table I have several Date fields such as: order_date payment_date purchasing_date estimated_delivery_date actual_delivery_date ... How to choose which ones that need to be linked to the Date_Dimension and the others? Thank you for your…
seeusoon
  • 45
  • 6
1 2 3
…
9
10