when will use SQL override in a lookup transformation?
No Answer is Posted For this Question
Be the First to Post Answer
What is partitioning? Explain about round-robin, hash partitioning.
how to load the data to fact table?
What is a lookup table in etl?
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 the concerns of OLTP and DSS systems?
what is the advantage of persistent cache? when it should be used?
Explain about the data integration suite features?
SCD2 will work on only dimension tables as well as fact Table?
Explain and compare etl & manual development?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?