what is the use of server manager?
How to fine tune mappings?
flat filevalidation in informatica
Define slowly changing dimensions (SCD)?
What is partitioning? Explain different types of partitioning?
What is a staging area? What is the purpose of a staging area?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
When do we go for the tools in the market?
how would u estimate the size of Lookup transform data and index cache?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is pmrep command?
what is the difference steps for data modeling?
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?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge