Informatica Interview Questions and Answers
Ques 6. What is a Workflow in Informatica?
A workflow in Informatica is a set of instructions for the integration service to execute the tasks defined in a mapping.
Is it helpful?
Add Comment
View Comments
Ques 7. Explain the concept of a Router transformation.
A Router transformation in Informatica is used to route data rows to different transformation logic based on specified conditions.
Is it helpful?
Add Comment
View Comments
Ques 8. What is a Repository Service in Informatica?
The Repository Service in Informatica is responsible for managing connections to the repository and providing access to the metadata stored in the repository.
Is it helpful?
Add Comment
View Comments
Ques 9. Differentiate between static and dynamic cache in Informatica.
Static cache is populated at the beginning of a session and does not change during the session, while dynamic cache can be updated during the session.
Is it helpful?
Add Comment
View Comments
Ques 10. What is a Rank transformation, and how is it used?
A Rank transformation in Informatica is used to select the top or bottom 'n' rows based on a specified condition or column.
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?