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

Time span accumulating fact tables design

I need to design a star schema to process order processing. The progress of an order look like this: Customer C place an order on item I with quantity 100 Factory F1 take the order partially with quantity 30 Factory F2 take the order partially with…
Phạm Văn Thông
  • 743
  • 2
  • 7
  • 21
1
vote
1 answer

How to merge facts from two different database into Fact table in Datawarehouse?

I have two different database A and B. I would like to create Fact table in my Datawarehouse which consists of facts from two databases.i.e I would like to create single fact from both databases. I would like to create "Revenue" column in my fact…
biggboss2019
  • 220
  • 3
  • 8
  • 30
1
vote
2 answers

FactLoanVolume - One or Many Fact Tables

I am designing a Fact table to report on loan volume. The grain is one row per loan transaction. A loan has a few major milestones that we report on: In order of sequence, these are Lock Volume, Loan Funding Volume and Loan Sales Volume. I have…
EyeBikeRide
  • 13
  • 3
1
vote
2 answers

Best query for getting success/failure ratio from warehouse fact table

I'm trying to fine tune a query and would like some feedback. I have a job_fact warehouse table with an unit of measure for the job's final event (final_event_type). I'm trying to run a query on the fact that will give me a success/failure ratio.…
localshred
  • 2,244
  • 1
  • 21
  • 33
1
vote
2 answers

Relation between two Fact tables

According to data warehouse concepts, is it correct to have a relation (1-m or even m-m) between two fact tables? Twetter scenario would be an example. We can suppose that we have two Fact tables (Tweets and Users). If we want to know which user has…
Ziad Salem
  • 496
  • 13
  • 34
1
vote
2 answers

Mini-dimension and DateTime

I am designing my first DWH system and have ran into a use-case which I did not find in any books/articles. Let's say that I have following dimensions: Student Subject And I have the a single fact table: Grading The dimension called Student is…
Jovan Perovic
  • 19,846
  • 5
  • 44
  • 85
1
vote
1 answer

SSIS - Incremental Load - Lookup Object

I am building a SSIS project in order to create an ETL to load a Data Warehouse that uses a star schema model. I've 3 dimensions: - Customer (Customer_ID, Customer_Name, Email) - Employees (Employee_ID, Employee_Name, Salary) - Product…
John_Rodgers
  • 181
  • 1
  • 11
1
vote
2 answers

Periodic snapshot fact table - Possibly missing some captures

I am tracking employee changes daily in a DimPerson dimension table, and filling up my fact table each end-of-month and counting Hires, Exits, and Headcount. For this example, let's say I will be populating the fact table end-of-month April 30th.…
Alistair
  • 621
  • 1
  • 7
  • 22
1
vote
1 answer

Sould I split up fact table by different source queries? Datawarehouse best practice

I think it's time for my first question on stackoverflow. Until now i've always found an answer to my questions, but now I have a very specific question for fact table design. Right now i have one fact table and the question is, if i should split it…
Jonnyblacklabel
  • 31
  • 3
1
vote
1 answer

Multiple Fact Tables-Kylin

I am aware that Apache Kylin only allows one Fact Table per OLAP cube. Is there a way to analyse a database with multiple Fact Tables using OLAP? Alternatively, Can we query from multiple cubes simultaneously in a single job on Apache…
anishdhiman
  • 41
  • 9
1
vote
0 answers

How to use temp table for ETL during populating Star schema?

I have the scripts to pull data from RDBMS and populate the Data warehouse. It works. I was wondering how Temp table comes in between. What are the steps to ETL exactly? Even though my data warehouse is populated, my teacher says that we need to use…
DazedNConfused
  • 189
  • 2
  • 13
1
vote
1 answer

Should the "count" measure be stored in the fact table?

I have a fact table that includes "wait times in hours" for certain services. I have a lot of dimensions that could describe the wait-times based on different slices; however, I am also interested in knowing how many people (counts) came for…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
1
vote
2 answers

Name Value pairs and fact tables

I'm working on a star schema for analysis of posted form data. The site that the form data will be posted to is actually external to the site hosting the form, so only the data in the form will be available. I'm going to give the option to include…
Simon Farrow
  • 1,901
  • 2
  • 20
  • 26
1
vote
2 answers

DW Factless Fact Table w/ Transactional Free Form Fields

I am reconstructing a Factless Fact table from a transaction table. There are obvious shared dims like Org, Status, Service, ServiceAction, Send Date, etc. However, There are 2 issues I'm trying to work through: On the Transaction table there…
user3998848
  • 73
  • 1
  • 6
1
vote
1 answer

SSAS - Is there a way to have a dimension relate to a fact table based on two columns in the fact table?

In SSAS is there a way to have a dimension relate to a fact table based on two columns in the fact table? We have two tables: Location (Dimension) and Sales (Fact). The Location dimension has one column: "state". The Sales table has three columns:…
msandler
  • 11
  • 2
1 2
3
…
9 10