what is the meant by Normalization and de-normalization?
No Answer is Posted For this Question
Be the First to Post Answer
What are the key benefits of ETL Testing?
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 automate Extraction process?
what is the difference between normal & bulk loading? and which one is recommended ? why?
When do we analyze the tables?
What is a mapping, session, worklet, workflow, mapplet?
What is the difference between round-robin partitioning and hash partitioning?
what are the different forms of normalization?
what is HISTOGRAM? how to generate statistics?
how do u decide whether u need to do aggregations at database level or at Informatica level?
how do u identify the changed records in operational data?
Explain the difference between etl tool and olap tools?