what is the meant by Normalization and de-normalization?
- 2 Answers
- 7718 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
Explain different types of partitioning?
what is Forward,Reverse and Re_engineering?
how do u really know that paging to disk is happening while u are using a lookup transform?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Is apache nifi an etl tool?
what are the data modeling tools you have used?(polaris)
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What is data cleaning?
What are the different etl testing categories as per their function?
Two default user groups created in the repository are____and_____.
Do we need an ETL tool? When do we go for the tools in the market?
what are the concerns of OLTP and DSS systems?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
flat filevalidation in informatica
Define slowly changing dimensions (SCD)?
