Informatica вопросы и ответы для интервью
Вопрос 31. Explain the concept of a Data-driven session in Informatica.
In a Data-driven session in Informatica, the session properties and mappings are determined at runtime based on metadata, allowing dynamic control of the ETL process.
Вопрос 32. What is the purpose of a Unconnected Stored Procedure transformation?
The Unconnected Stored Procedure transformation in Informatica is used to execute stored procedures that are not connected to the pipeline and do not return a value.
Вопрос 33. How can you handle slowly changing dimensions in Informatica?
Slowly Changing Dimensions (SCD) in Informatica can be handled using techniques such as Type 1 (overwrite), Type 2 (historical), and Type 3 (add new column).
Вопрос 34. Explain the concept of a Dynamic Partitioning in Informatica.
Dynamic Partitioning in Informatica allows the Informatica server to dynamically determine the number of partitions based on the available system resources.
Вопрос 35. What is the purpose of a Target Load Plan in Informatica?
A Target Load Plan in Informatica specifies the order in which target tables are loaded, providing control over the loading sequence in a session.
Самое полезное по оценкам пользователей:
- 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?