Informatica Questions et reponses d'entretien
Question 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.
Question 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.
Question 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.
Question 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.
Question 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.
Les plus utiles selon les utilisateurs :
- 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?