Interested to Buy Any Domain ? << Click Here >> for more details...
what is the meant by Normalization and de-normalization?
- 2 Answers
- 8831 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 |
what is the use of structures?how many nodes can u create in a structure?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
what are Lookup caches options? Including persistent caches.
what is Forward,Reverse and Re_engineering?
Difference between flat files and relational sources?
What is a mapping, session, worklet, workflow, mapplet?
what is session partitioning?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is the difference between shortcut of an object and copy of an object? compare them?
What is tracing level and what are the types?
how do u set partition points in the mapping?
Teradata 
