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?