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 happens if the info.server doesn't find the session parameter in the parameter file?
How to Check the source record count from traget table.
What is data cleaning?
how do u extract data from different data sources explain with an example?
Explain about the data integration suite features?
Explain what is etl process? How many steps etl contains explain with example?
what happens if the info.server doesn't find the session parameter in the parameter file?
explain the methodology of Data Warehousing?(Polaries)
Identifying the bottlenecks in various components of Informatica and resolving them.
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
What is etl process. How many steps etl contains explain with example?
what are the reports developed in sap bw project and what is the requirement for developing it?