Interested to Buy Any Domain ? << Click Here >> for more details...
what is the meant by Normalization and de-normalization?
- 2 Answers
- 8737 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 |
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what are the cubes developed in a sap bw project and what is the requirement for developing it?
How we can see table structure?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
What are cubes and olap cubes?
dimension object created in oracle can be imported in designer?how?
What is the difference between round-robin partitioning and hash partitioning?
how many steps are there in etl process?
what are the concerns of OLTP and DSS systems?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What are the ETL Testing Operations?
How can we use external procedural logic in informatica?
Teradata 
