Denormalized used too often with dimensional data designs. More likely reorganized to bring out the dimensions trapped inside of a header table. Not more summarized. Summarization only for aggregate tables that aren’t needed often anymore. Kimball and Ross read.
Very well explained :)
Everyone needs to read it! Let me share it then...
Denormalized used too often with dimensional data designs. More likely reorganized to bring out the dimensions trapped inside of a header table. Not more summarized. Summarization only for aggregate tables that aren’t needed often anymore. Kimball and Ross read.
If we create replica database (as is), can we remodel the data from OLTP to OLAP? Hows the effort like?
Excellent post!