what is the meant by Normalization and de-normalization?
- 2 Answers
- 8091 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 |
Hi, Lookup() is what kind of join ?
Two different admin users created for repository are________and_________.
What is the main difference between peek stage and copy stage
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the reports developed in sap bw project and what is the requirement for developing it?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
what make u disappointmnets in u r career
How can we use external procedural logic in informatica?
what is pmrep command?
Explain about enterprise scalability and roi of data integration suite?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
Teradata 
