What is a materialized view log?
No Answer is Posted For this Question
Be the First to Post Answer
What is a lookup table in etl?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
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.
list and discuss two approaches for updation of target table in Informatica and how they are different.
What is a mapping?
how do u implement scheduling in Informatica?
what are Lookup caches options? Including persistent caches.
What are the modules in Power Mart?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
Identifying the bottlenecks in various components of Informatica and resolving them.
What do you understand by the term ‘transformation’?
Explain and compare etl & manual development?