There seems an obvious advantage in giving warehouse dimensions and facts their own schema (dim, fact); but it might be more imagined than real.  I have started using this separation; it allows the dim table prefix to be dropped which … Continue reading →