Post New Answer View All Answers
Define filter transformation?
Explain target update override in informatica
Explain constraint based loading in informatica
Explain the informatica workflow?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is target load order?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the prerequisite tasks to achieve the session partition?
What is the difference between Active and Passive transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the difference between a connected look up and unconnected lookup?
What is the different lookup cache(s)?
What is a mapplet/worklet in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to improve the performance of a session using sorter transformation?