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 etl process?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
how do u really know that paging to disk is happening while u are using a lookup transform?
Identifying the bottlenecks in various components of Informatica and resolving them.
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Which transformation we use to convert 'NA' to 'Not Available'
what is SMP AND MPP?
How to know informatica conslole password??
what is the main role of FI on business
how many steps are there in etl process?
what is the difference steps for data modeling?
what are the different forms of normalization?