Informatica 面接の質問と回答
質問 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.
質問 22. What are the different types of transformations in Informatica?
Informatica supports various transformations, including Aggregator, Filter, Router, Lookup, Expression, Joiner, and many others.
質問 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.
質問 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.
質問 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.
ユーザー評価で最も役立つ内容:
- 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?