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?