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
Define Dynamic push down optmization?
how would u estimate the size of Lookup transform data and index cache?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is the use of server manager?
what is granularity in Data ware House?
how do u extract data from different data sources explain with an example?
what is the meant by Normalization and de-normalization?
Which transformation we use to convert 'NA' to 'Not Available'
List few etl bugs?
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what are Lookup caches options? Including persistent caches.
What are the types of Data Warehouse applications?
Explain the use lookup tables and Aggregate tables?
what is the difference steps for data modeling?