how would u estimate the size of Aggregator transform data
and index cache?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Difference between flat files and relational sources?
What is etl process. How many steps etl contains explain with example?
In Which Transformation We Can Use Having Clause In Informatica?
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 access a repository created in previous version of Informatica?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
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
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
Can u access a repository created in previous version of Informatica?
How etl testing is different from database testing?
how do u implement configuration management in Informatica?