Faculty of Engineering and Mathematical Sciences 
Not logged in (login)

help3401


This forum is provided to promote discussion amongst students enrolled in Data Warehousing (CITS3401).
 
Options:
RSS cloud
Jump to:

Lecture 4: 60,000 possible dimension table rows

1 of 251 articles shown, currently no other people reading this forum.
photo
From: Edward A.
Date: Tue 24th Mar, 9:57pm
Actions: 
        Login-to-reply
Hi Zeyi ,

I was just wondering how you calculated that each dimension table in scenario C for the example you ran through in lecture 4 would have 60,000 possible rows? 

Wouldn't it be possible for a dimension to have 100 million unique values if there are 100 million facts in the fact table? How can you be certain there would be only 60,000 possible values for each dimension, or is that simply an assumption?

Related articles

Lecture 4: 60,000 possible dimension table rows (all 3) RSS
├─ THIS   Tue 24th Mar, 9:57pm, Edward A.
├─ reply 1   Sun 29th Mar, 11:44am, Edward A.  O.P.
└─ reply 2   Sun 29th Mar, 8:35pm, Zeyi W.
This Page


Program written by: [email protected]
Feedback welcome
Last modified:  8:27am May 24 2020