Explain what is etl process? How many steps etl contains explain with example?
Can u access a repository created in previous version of Informatica?
What is virtual Data Warehousing?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is SMP AND MPP?
What is cube grouping?
What is partitioning? Explain different types of partitioning?
how do u implement unconn.stored proc. in a mapping?
Eliminating of duplicate records without using dynamic lookups
What are the key benefits of ETL Testing?
how do u implement configuration management in Informatica?
what is the use of server manager?
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?