what is the meant by Normalization and de-normalization?
Answer Posted / gireesh
Normalization is a process in database design which groups
data into various tables which are then crosslinked by a
particular field. In a properly normalized database, there
will be only one field in one table for a particular piece
of data, eliminating possibility for conflicts. Breaking the
database up into numerous smaller tables, and eliminating
redundancies, eases management and enhances efficiency.
| Is This Answer Correct ? | 24 Yes | 5 No |
Post New Answer View All Answers
what is an ETL or ETT? And what are the different types?
how many steps are there in etl process?
Difference between flat files and relational sources?
what is session partitioning?
How many steps etl contains explain with example?
When do we analyze the tables? How do we do it?
what is session partitioning?
Explain about round-robi?
Two default user groups created in the repository are____and_____.
what is the difference between cubes and package in cognos
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What are the different etl testing categories as per their function?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is a mapping, session, worklet, workflow, mapplet?
what are the facilities provided by data warehouse to analytical users?