Thanks for the reply.

But even if i don't use it right now, i d like to know when and where to do it.

DataWarehouses is obvious that must be denormalized. 😉