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
2
votes
1 answer

SQL insert into select from - insert the id instead of the data

I need to populate my fact table with data from lds_placement table. I have selected the records and here is what it looks like: fk1_account_id | fk3_job_role_id | salary | no_of_placements | …
DazedNConfused
  • 189
  • 2
  • 13
2
votes
1 answer

Fact table design guidance for 100s of facts

I'm trying to create a datamart for the healthcare application. The facts in the datamart are basically going to be measurements and findings related to heart, and we have 100s of them. Starting from 1000 and can go to as big as 20000 per exam…
May
  • 100
  • 1
  • 9
2
votes
2 answers

Transaction Fact Table approach

I'm working on financial data mart structure. And I'm having some doubts on whats the better approach to do so. The source system database,Dynamics AX 2009, has three tables for customer transaction. One table for open transactions, where the…
vinomalino
  • 55
  • 1
  • 5
2
votes
3 answers

Understanding the fact tables in data warehousing

Using a basic star schema, I have been told that a fact table would have at least the amount of rows equal to the product of the number of rows in each dimension. For example, 3 products, 5 promotions, and 10 stores would mean that the fact table…
Luke
  • 776
  • 9
  • 24
2
votes
1 answer

I've populated the dimensions - how to populate the fact table?

I've populated 4 dimensions tables these being a time dim, site dim, abandoned dim and worktype dim. I've calculated the measures needed in the end fact table in a staging table but how do I transfer the dimension ID's and the measures into the fact…
Richard C
  • 389
  • 2
  • 5
  • 16
2
votes
1 answer

Dimensional design: not sure about fact vs. dimension for a certain types of data

I'm having some trouble deciding what should go in a particular dimension and what should go in a fact table for a star schema I'm developing. For the sake of example, let's say that the project is keeping track of houses for a property management…
siride
  • 200,666
  • 4
  • 41
  • 62
1
vote
1 answer

Error 1774 in SQL Server

I am trying to create a fact table in my database, and so I need to insert a lot of foreign keys. I get the following error when trying to insert a specific foreign key: The number of columns in the referencing column list for foreign key …
user1264578
  • 43
  • 1
  • 1
  • 5
1
vote
2 answers

Using "Fact" Relationship Type on the "Dimension Usage" tab in a SSAS OLAP cube

I was hoping someone could explain the appropriate use of the 'FACT Relationship Type' under the Dimension Usage tab. Is it simply to create a dimension out of your fact table to access attribute on the fact table itself? Thanks in advance!
Mike Larke
  • 11
  • 1
  • 3
1
vote
1 answer

What's the difference between a DataMart and a Fact Table?

I actually don't understand the exact meaning of DataMart. For instance , if my datawarehouse has 4 fact tables , does that necessarily mean I have 4 datamarts? These are the HR fact tables I…
userrr
  • 197
  • 7
1
vote
0 answers

Timescale: Index scan - performance

I have the following tables in timescale db Fact table: fact_program_event_audience (hypertable table): create table v1.fact_program_event_audience ( event_id uuid, content_id text, …
Vlad Kuzmich
  • 21
  • 1
  • 5
1
vote
0 answers

Multiple Fact Tables Slice one table with second table categories

I looked around A LOT but could not find the answer, I'd appreciate some help here! I have a data model with 2 fact tables: [A] Product Sales & [B] Expenses Per Product Per Channel. I need to report based on the Sales [A] so my goal is to be able to…
Tomas Moreno Plese
  • 11
  • 1
1
vote
1 answer

Merge statement in SNOWFLAKE database on primary key error

I am kinda confused with the way merge statement has to be written in my scenario to load data from a table into dimension and fact tables. Below is the merge statement where I am trying to load data into my DIM product table from the JSON table but…
SMR
  • 401
  • 4
  • 15
1
vote
1 answer

How to get the correct table as a Fact Table with relevant keys?(Star Schema)

I have a problem to select the suitable table for the fact table. I have problem with following two tables OrderData Table…
user12760080
  • 11
  • 3
1
vote
1 answer

Fact table updatable/deletable rows

AFAIK, the best practices say that you should never updated fact table rows, at least for transaction and periodic snapshot grains. While reading about Fact Table Surrogate Key, found a notion of updates: Certain ETL techniques for updating fact…
VB_
  • 45,112
  • 42
  • 145
  • 293
1
vote
0 answers

How to Improve this Star Schema Design

I'm taking a course on Business Intelligence and I have to deal with a Star Schema for the first time in about 3 years so I wanted your feedback on what I've done if possible and see if there is anything I can do to improve my current design. So…
Javier Ruiz Velez
  • 35
  • 1
  • 1
  • 5
1
2
3
…
9 10