Informatica Interview Questions and Answers
Ques 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.
Ques 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.
Ques 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.
Ques 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.
Ques 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.
Most helpful rated by users:
- 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?