Informatica Interview Questions and Answers
Ques 36. Explain the concept of a Parameter File in Informatica.
A Parameter File in Informatica is a text file that contains parameter values used to replace placeholders in session and workflow properties at runtime.
Is it helpful?
Add Comment
View Comments
Ques 37. What is the purpose of a Router transformation in Informatica?
A Router transformation in Informatica is used to filter data rows to different output groups based on specified conditions.
Is it helpful?
Add Comment
View Comments
Ques 38. Explain the concept of a Sorter transformation.
A Sorter transformation in Informatica is used to sort data based on one or more columns before passing it to the target transformation.
Is it helpful?
Add Comment
View Comments
Ques 39. What is a Lookup Override in Informatica?
A Lookup Override in Informatica allows you to override the default SQL query generated by the Lookup transformation to customize data retrieval.
Is it helpful?
Add Comment
View Comments
Ques 40. Explain the concept of a Surrogate Key in Informatica.
A Surrogate Key in Informatica is a system-generated key used to uniquely identify rows in a dimension table, often replacing natural keys for efficiency.
Is it helpful?
Add Comment
View Comments
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?