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?