what is the meant by Normalization and de-normalization?
- 2 Answers
- 8127 Views
- I also Faced
- E-Mail Answers
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
How etl testing is different from database testing?
what is the meant by Normalization and de-normalization?
how would u estimate the size of Aggregator transform data and index cache?
State the differences between shortcut and reusable transformation
Explain the use lookup tables and Aggregate tables?
What is data cleaning?
how to connect to a flatfile through ftp in informatica
dimension object created in oracle can be imported in designer?how?
Explain what is etl process? How many steps etl contains explain with example?
what is the use of structures?how many nodes can u create in a structure?
what is dynamic insert?
when will use SQL override in a lookup transformation?
What is staging area referring to?
Explain and compare etl & manual development?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
