what is the difference between shortcut of an object and
copy of an object? compare them?
what is session partitioning?
what are the types in error loging?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
how do u set the size of block buffer?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
how would u estimate the size of Aggregator transform data and index cache?
Explain the use lookup tables and Aggregate tables?
if u can't find what you are looking for in lookup table, how do you handle?
what is the difference between OLTP database and data warehousing database?
What do you understand by the term ‘transformation’?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?