Which is the best normalization Level for a dataware house new system?
We are about to start the design of a new system data warehouse, using an Oracle 11g as our main database, we are currently discussing which is the best normalization level we should implement into our database design, we have heard some many point of view and I would like to know what do you think about the next 4 suggestions.
Use none normalization levels at all.
Use the first normalization level
Use the second normalizations level
Use the third normalization level
I hope you can help make the best choice
Thanks for all
Best Regards
José