what is the meant by Normalization and de-normalization?
Answer Posted / 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 |
Post New Answer View All Answers
How many types of transformations supported by sorted input?
What is the difference between round-robin partitioning and hash partitioning?
what is the difference between cardinality and Nullability?
Identifying the bottlenecks in various components of Informatica and resolving them.
Mention few test cases and explain them?
if i have a query as flat file how can we load data to target table
Can there be sub steps of etl steps?
Explain and compare etl & manual development?
Define Dynamic push down optmization?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Explain what are the various etl tools in the market?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What do you understand by active and passive transformations?
What are dimensions?
What is grain of fact?