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
how do u set partition points in the mapping?
How to fine tune mappings?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
what is the difference between cubes and package in cognos
how many steps are there in etl process?
if i have a query as flat file how can we load data to target table
How many types of transformations supported by sorted input?
What is a materialized view log?
Do we need an etl tool?
flat filevalidation in informatica
can be used COM component in Informatica ?
Explain about hash partitioning?
what is the difference steps for data modeling?
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.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.