Data Warehousing Community Forum
February 10, 2012, 12:54:38 am

Pages: [1]   Go Down
  Print  
Author Topic: Normalized and De-normalized Table  (Read 430 times)
praveen
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 4


View Profile
« on: July 10, 2010, 03:24:23 pm »

Hi Guys,

Can you please explain in the layman term, what is normalization and why do we use denormalized tables in the dataware housing.

Appreciate your help.

Thanks,
Praveen
Logged
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: July 15, 2010, 11:44:47 am »

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.
Logged

If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
 
Jump to: