fact table mainly consists of business facts and foreign keys that refer to primary keys in the dimension tables
Questions tagged [fact-table]
138 questions
-1
votes
1 answer
From starschema ETL to Datawarehouse
We are busy with an project for school. we have to build an Datawarehouse but im stuck.
I have the following starschema:
dim_location:
Location_key(Primary key)
City
dim_condition:
Condition_key(primary key)
Description(Example: Good, Bad, Very Bad,…
Nordip
- 29
- 3
-2
votes
1 answer
Can I store textual fields in fact table of Datawarehouse?
I have a fact table called Fact_Employee_Ratings, these are reviews about a company scrapped from Glassdoor. The review is actually divided into two parts, employees would give what they liked and what they disliked about the company. This is how I…
userrr
- 197
- 7
-3
votes
1 answer
What dimensions to use for a fact table Incident"
I want to build a fact table that hold information about incidents.
The dimensions I suggested:
Time_Dimension : ID_Time, Year, Month, Day
Location_Dimension : ( City for exemple) :ID_City, name
But what i don't get is, the datamart is supposed…
Safaa Jebari
- 1
- 2