what is the meant by Normalization and de-normalization?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinivas
Normalization:
Normalization is a technique to reduce redundant, and
inconscistent data. normally normalization techniques use
in snoflake schema.
De-normalization:
it is a technique to move high to low normal forms in
datamodeling to increase the performance of databases.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a materialized view log?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
Two default user groups created in the repository are____and_____.
when should one create lookup transformation ?
what is Forward,Reverse and Re_engineering?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Define Dynamic push down optmization?
what do u do when DB time takes more?in sap bi
When do we analyze the tables?
What is the main difference between peek stage and copy stage
What is the difference between project backlog and product backlog?
What are the new features of informatica 9 version?