hi,

i want to know that in what circumstances we do not need to normalize our tables

thnx

You always normalise your tables. Always.

you do not need to normalize your tables when they have only a few rows

the definition of "a few" varies, depending on the size of your server

a couple of hundred unnormalized rows, and you'll still be okay

however, despite the foregoing, you should normalize anyway

"Always normalize, then only denormalize if necessary"

However, data warehousing has somewhat different requirements than does an OLTP system

I can't think of any situation where you truly have to normalize a schema.

If you have infinite resources for problem resolution in your data (people), infinite disk for storage, infinite processing power to brute force crunch your data, and infinite memory to do the aforementioned crunching in, then there isn't much need for normalization.

I've never been blessed with a situation like what I've described, so I tend to be rather finicky about normalization myself.

-PatP