what is the meant by Normalization and de-normalization?
- 2 Answers
- 7895 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 |
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com
320 Answers Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,
how do u set the size of block buffer?
what is the difference between cardinality and Nullability?
How can we use external procedural logic in informatica?
what is data modeling?
What is a mapping, session, worklet, workflow, mapplet?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
How etl testing is different from database testing?
what is the use of server manager?
how do u set partition points in the mapping?
Teradata 
