What is Normalization?
- 3 Answers
- 8949 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinath gatpa
normalization is a process of spliting the table in to the
pices so that we can reduce the data redundancy problem
it contain more no. of tables so it will take more time to
execute
it will decreases the performence
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
Answer / suman palisetty
Normalization is the process of reducing complexity by removing redundancy.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between aggregation and role up aggregation ?
what type of charts we create mostly in realtime? plz help
What is Local Cache and how does it help in performance tuning
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development
It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....
what is mean of Meta data definistions?
What is an olap designer?
What is Cardinality
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
Teradata 
