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
What is etl process? How many steps etl contains?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are snapshots?
What are the key benefits of ETL Testing?
How to delete data which is not in source table?
how many steps are there in etl process?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what are the facilities provided by data warehouse to analytical users?
where is the cache (lookup, index) created and how can you see it.
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.
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are cubes and olap cubes?
What is etl tool in hadoop?
What is abap? What are idocs?
What is virtual Data Warehousing?