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

5. Which type of report you build more, list, crosstab or chart and why?

1584


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

1495


How to a create header dynamically in a crosstab report in cognos 8.1?

1983


how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

1621


what is hints in cognos and where we use it.

1983






What are the types of hierarchies?

550


What are all the types of indexes in Cognos?

706


What is a Datastore in Cognos?

788


What are the different types of important services used in cognos?

577


What is a Query Subject?

651


4. How many dimensions did you use in your reports?

1487


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

534


------------------What is Inline Query?

1782


which type of project we r going to snowflake schema

1593


How to test a cube?

1667