This content has been marked as final. Show 2 replies
I want to ask you about the suitability of a Calendar implementation for a Dimensional Table.
Because I am thinking if I should move date fields to a dimensional tables from the fact table and do this approach. But if I do this, I am going to have a Snowflake schema.
So my question if it's better have most of the dates in the fact table even if they will fit better in a dimension, to have a Calendar implementation.