Informatica вопросы и ответы для интервью
Вопрос 41. How can you create a reusable session in Informatica?
A reusable session in Informatica can be created by defining the session as reusable in the session properties and saving it to the repository for use in multiple workflows.
Вопрос 42. What is the purpose of a Pre-Session Command in Informatica?
A Pre-Session Command in Informatica is used to execute commands or scripts before the session starts, allowing for custom initialization tasks.
Вопрос 43. Explain the concept of a Source Filter in Informatica.
A Source Filter in Informatica is used to filter rows at the source database level before they are read by the source qualifier, optimizing data extraction.
Вопрос 44. What is the purpose of a Data Masking transformation?
The Data Masking transformation in Informatica is used to mask sensitive data in a mapping, ensuring that confidential information is not exposed.
Вопрос 45. How can you handle null values in Informatica?
Null values in Informatica can be handled using functions like ISNULL and COALESCE, or through the use of NULL indicator ports in transformations.
Самое полезное по оценкам пользователей:
- 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?