I have only one short question regarding data model.
If we have small data set than it is probably not so important how we structure our data model (all data in a one flat file).
The question is: if we have larger data sets, should we always tray to build a star schema in our data model?
Snowflake has more joins (it is more normalized) and i think we could suffer some performance penalties in case of a larger data sets.
Is my thinking correct? Please write down some opinions.