Can you please explain in the layman term, what is normalization and why do we use denormalized tables in the dataware housing.
Normalization is the process of separating the various entities or "levels" of data into their own tables, and maintaining the relation between these entities using "keys".
This allows for more organized and optimized data storage, often at the cost of performance.
Since a data warehouse is usually more concerned with performance than with storage space, denormalized data models are preferred.