Informatica Interview Questions and Answers
Ques 21. Explain the concept of Data Transformation Manager (DTM) in Informatica.
The Data Transformation Manager (DTM) in Informatica is responsible for the execution of tasks within a session, such as reading, transforming, and loading data.
Is it helpful?
Add Comment
View Comments
Ques 22. What are the different types of transformations in Informatica?
Informatica supports various transformations, including Aggregator, Filter, Router, Lookup, Expression, Joiner, and many others.
Is it helpful?
Add Comment
View Comments
Ques 23. How can you improve session performance in Informatica?
Session performance in Informatica can be improved by optimizing transformations, using partitioning, increasing cache size, and tuning session properties.
Is it helpful?
Add Comment
View Comments
Ques 24. Explain the concept of a Dynamic Lookup Cache.
A Dynamic Lookup Cache in Informatica is created at runtime and allows the addition of new entries during the session.
Is it helpful?
Add Comment
View Comments
Ques 25. What is the purpose of a Source Qualifier transformation?
The Source Qualifier transformation in Informatica is used to specify properties for reading data from a relational or flat file source.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users:
- What is Informatica PowerCenter?
- What is a Repository Service in Informatica?
- Explain the concept of a Source Filter in Informatica.
- What is a Lookup Override in Informatica?
- What is a Session in Informatica?