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

In Data Warehousing, Should a Data Model have less+large Dimension Tables or split into more+small Dimension Tables?

I've just started learning Data Modeling in DW. And now I'm a bit confused about choosing with field to build a Dimension Table and whether should I split into many DIM tables For example, I have a Employee Table and it's columns as below: …
Hoang Minh Quang FX15045
  • 733
  • 1
  • 4
  • 15
0
votes
1 answer

Should I add Foreign Key constraint when creating Fact Table in SQL?

The question is a bit naive. But when I learned, it's said that you should add both Primary Key and Foreign Key to Fact Table as below: About the Primary Key in Fact Table, there're many posts on the internet about this and I've already got some…
Hoang Minh Quang FX15045
  • 733
  • 1
  • 4
  • 15
0
votes
0 answers

Dealing with multiple fact tables concerning related processes in dimensional modeling

I have the following scenario where OLTP sales data is stored in two separate physical tables: Sales Refunds/Cancellations A refund always refers to an existing sale (thus 'negating' it), though the dimensions of these tables are nearly the same…
filpa
  • 3,651
  • 8
  • 52
  • 91
0
votes
2 answers

How to represent different business facts in a single fact table?

I have the following dimensional tables: DimUser DimClient DimLocation DimDate DimTime DimLog DimStatuses How could I represent the following events in the fact table? Logs by user over time User status change over time Let's say the fact table…
Sebastian Correa
  • 43
  • 1
  • 8
0
votes
1 answer

How different fact tables are handled to share some common dimension tables in data marts in star model?

I am quite new to DW and I am just learning the stuff. I read on the Internet that after the ETL process, DW data is then stored in some data marts for some reasons such as ease of use. Each data mart can use a structure. Let's say a data mart is…
ssaf
  • 86
  • 1
  • 6
0
votes
1 answer

In this specific example, can I have more than one fact table?

I have the following assignment for Business Intelligence Class: "The CSUF Business Association is conducting a babysitter service as a fundraiser for different clubs in college. When a customer is entered into the system, the CSUF Club coordinator…
user17510097
  • 5
  • 2
0
votes
1 answer

How to populate fact table with Surrogate keys from dimensions?

Could someone please help me understand how to populate the fact table with Surrogate keys from dimensions using SSIS? I load my dimension tables and assign for each a surrogate key. I want to add these surrogate keys to my fact table but I don't…
chaneb
  • 67
  • 1
  • 6
0
votes
1 answer

SQL filtering counts in a fact table using a subquery or better alternative

I am trying to summaries data from my Data Warehouse into a fact table and I want to be able to count up the number of transactions per type that there were per customer per month. Columns being used are: Customer_id, Transaction_id,…
Patrick Gillett
  • 3
  • 1
0
votes
0 answers

Is there better approach to model the event? Evolving to discrete event

I have a few questions about one of my process implementations in the DW. It would be great if you can provide your suggestion. At a high level how business works Requester requests quotes --> lenders provide quotes --> requester acts on quote. I am…
user16344431
0
votes
1 answer

Power BI : Need to add columns to table visual based on slicer selection

I have a use-case wherein I am pulling a huge fact table from Azure Data Explorer and I need to create a table visual where there are few fixed columns in the visual and I need to provide a slicer with columns from the same fact table, this slicer…
Pratik Somaiya
  • 695
  • 5
  • 18
0
votes
0 answers

Order and delivery DW

Now I am working on my project I need to create a data warehouse, we have an application where a client can place an order, One order can be sent in multiple deliveries(even for the same product for example if he asked for 5 when can send the first…
Rita
  • 3
  • 2
0
votes
1 answer

Star schema Sales and goal

I have a star schema, the fact table is sales I have a product, region date dimension (date, year, month, day). Now I have a file that contains goals of sale by year and month , Now i need to compare the goal of sale with the real value (from sale…
andy
  • 47
  • 5
0
votes
2 answers

Star Schema from multiple source tables

I am struggling in figuring out how to create a star schema from multiple source tables. I work at a trading firm so the data is related to user trading activity. The issue I am having is that our datasets do not have primary ids for every field…
Jonathan Duran
  • 79
  • 5
0
votes
1 answer

Calculate number of rows of base fact table

I would like to get some helpful insight about a situation I stuck. I try to calculate the number of rows of a fact table. Time Dimension : 10 years Branch Dimension : 3000 branches in 35 countries Product Dimension : 1000 products…
Aeron
  • 1
  • 1
0
votes
1 answer

SQL statement to combine fact table and dimension table?

If I have a fact table and a dimension table, for example, as below: fact_table fact_key dim_key revenue cost dimension_table dim_key advertiser product Fact table has 4 rows and dimension table has 3 rows. How do I combine two tables?
Jayden Rice
  • 301
  • 1
  • 14
1 2 3
…
9 10