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 is meant by incremental load?
Explain do we need an etl tool?
how do u extract data from different data sources explain with an example?
What is a mapping?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
Can we create Hierarchies in generic datasources?
what are the data modeling tools you have used?(polaris)
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are your responsibilities as an etl tester?
What is a lookup table in etl?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
explain the methodology of Data Warehousing?(Polaries)