what is the meant by Normalization and de-normalization?
Answer Posted / 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 |
Post New Answer View All Answers
Explain about power designer data modeling software?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
Compare etl & elt?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Do we need an etl tool?
what is the use of server?
what are Lookup caches options? Including persistent caches.
what happens if the info.server doesn't find the session parameter in the parameter file?
Can we create Hierarchies in generic datasources?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
What are cubes and olap cubes?
What is the difference between Data Warehousing and Data Mining?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are various etl tools in the market?