Informatica perguntas e respostas de entrevista
Pergunta 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.
Pergunta 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.
Pergunta 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).
Pergunta 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.
Pergunta 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.
Mais uteis segundo os usuarios:
- 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?