Forum Discussion
Understanding Star Schema? One Lookup Table vs Many
I am trying to build out the Star Schema and I am utilizing a fake corporate structure with regional stores. When building the lookup table, would it be better to build a separate lookup table fo...
Read about Normalization and the different levels (forms) all the way up to NF6.
In a real world scenario you can stop at level 2 or 3, no need to overthink this, especially not when the denormalized version (flat table) is not too big.