Home | Contact Us | Sitemap
DWHlabs provides Data Warehouse education services.This web portal is very useful to the Database professionals,
Data Warehouse professionals, UNIX professionals etc.,
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
 
 
Please help us continue development of this website and it's services!
 
 

 


 
DWH CONCEPTS
   
Sponsered Links
 
 
Vs Links
7
NORMALIZATION VS DENORMALIZATION
 
Ans
NORMALIZATION
DENORMALIZATION
Normalization: is a gradual process of removing redundancies of attributes in a data structure. The condition of the data at completion of each step is described as a "normal form." Normalization is usually considered to be a good way to design a database, however it involves high CPU time to process a task or query.
Denormalization: is the reverse of normalization wherein the emphasis is on increasing redundancies. This is done for performance enhancement and reduced query time.
Fact table in Normalization form. Dimensional tables are in denormalized form.




 
DWH 3Colors
CERTIFICATION GUIDE
DATA DICTIONARY
ALL ARTICLES
   
DWH CONCEPTS

DWH Architecture
Types of Schema
Normalization

VS LINKS

OLAP Vs OLTP
Dimension Table Vs Fact Table
Datamart Vs Data Warehouse
Data Mining Vs Web Mining


SHARE KNOWLEDGE

Now viewers can share their information with DWHlabs , please
Click Here.
Please send your feedback
Click Here .
Tell you friend about DWHlabs
Click Here .


Data Warehouse Lab

- ETL TOOL
INFORMATICA
OTHER TOOLS

- REPORTING TOOL

BUSINESS OBJECTS
OTHER TOOLS

Database Lab

- ORACLE
SQL
PL/SQL

- DB2
OTHER TOOLS

Unix Lab

Project Lab

DWH Schools

Books Store



 
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
© 2008 DWHlabs
Privacy Policy | Terms & Conditions