CODEWITHSUNDEEP
reportingrdbmsdata-warehousestar-schema
Itay Moav -Malimovka
Itay Moav -Malimovka

Reputation: 53606

Is the user table considered a dimension or part of fact

I am designing a star scheme db where the fact is user login.
My dimensions are time (up to hour of day) and location (based on IP).
I have about 300k users in my system. This size grows by 5k/year.
Should the user details be part of the fact table or a dimension table onto itself?

Upvotes: 0

Views: 1179

Answers (2)

NITHIN B
NITHIN B

Reputation: 334

Facts are usually created for business activities.

I believe your business activity (in this scenario) would be a user logging at a particular time.

Fact table: Fact_User_Login Dim Tables:Dim_User,Dim_Date_Time, Dim_Location

This is just an example.

Hope that helps

Cheers Nithin

Upvotes: 3

Rich
Rich

Reputation: 2279

User details are descriptive of the user and should be in a dimension.

Upvotes: 2

Related Questions