What is Normalization?

Answer Posted / sharath.dwh


NORMALIZATION MEANS TAKING A RAW DATABASE AND BREAKING IT
INTO LOGICAL UNITS CALLED TABLES IS CALLED NORMALIZATION.


DENORMALIZATION MEANS TAKING A NORMALIZED DATABASE AND
MODIFYING IT TO ALLOW CONTROLLED REDUNDANCY
FOR INCREASING DATABASE PERFORMANCE IS CALLED
DENORMALIZATION.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2163


how can I test reports in cagnos?

634


Can you define report item?

592


What are products of cognos?

564


-----------With out using DrillThrough how to do Reports?

1606






What is difference between page break and section report? What is main advantage datawarehousing over oracle?

607


What do you understand by the term 'aggregate cache'?

573


What is the advantage of using shortcuts?

644


What is defined as Query studio?

619


how you provide security to reports? How you provide security to packages ?

636


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1957


Why is auto-regression used in forecasting used on cognos platform?

542


What do you understand by the term 'dynamic cube'?

568


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

577


What do you understand by the term 'model durability'?

570