tabinsc (4/20/2011)
I would argue that sometimes you may have redundant data in your database to make reporting easier and faster.
There is a difference between redundant data in one table (like a dimension) and redundant data between different tables.
I would argue that the last one should be avoided, where the first one is ideal for reporting.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP