Informatica вопросы и ответы для интервью
Вопрос 11. Explain the concept of a Lookup transformation.
A Lookup transformation in Informatica is used to look up data in a relational table or view based on a condition and retrieve related values.
Вопрос 12. What is the difference between a connected and an unconnected Lookup transformation?
A connected Lookup transformation is connected to the pipeline, while an unconnected Lookup is not connected to the pipeline and must be called by another transformation.
Вопрос 13. How is parameterization achieved in Informatica?
Parameterization in Informatica is achieved through the use of parameter files, which contain values that can be substituted into session and workflow properties at runtime.
Вопрос 14. Explain the concept of Partitioning in Informatica.
Partitioning in Informatica involves dividing the source data into subsets to be processed in parallel, improving session performance.
Вопрос 15. What is the purpose of the Aggregator transformation?
The Aggregator transformation in Informatica is used to perform aggregate calculations such as sum, average, minimum, maximum, etc., on groups of data.
Самое полезное по оценкам пользователей:
- 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?