Interested to Buy Any Domain ? << Click Here >> for more details...
what is the meant by Normalization and de-normalization?
- 2 Answers
- 8731 Views
- I also Faced
- E-Mail Answers
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 |
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
Eliminating of duplicate records without using dynamic lookups
What are the different Lookup methods used in Informatica?
What is the difference between Data Warehousing and Data Mining?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
what are the facilities provided by data warehouse to analytical users?
What is virtual Data Warehousing?
what is meant by drill through?(Mascot)
Identifying the bottlenecks in various components of Informatica and resolving them.
what is dynamic insert?
how to load the data to fact table?
Define slowly changing dimensions (SCD)?
Teradata 
