Eliminating of duplicate records without using dynamic lookups
what are the parts of Informatica server ?
How many types of transformations supported by sorted input?
What is data cleaning?
what is the indicator file and where it is used?
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.
what are Lookup caches options? Including persistent caches.
Explain and compare etl & manual development?
What are the modules in Power Mart?
Explain the key challenges that you face while performing etl testing.
what is the difference between normal & bulk loading? and which one is recommended ? why?
Explain do we need an etl tool? When do we go for the tools in the market?
What are materialized views & where do we use them?