Answer Posted / abhinav
Update Override is an option in Informatica at the session
level. In this, you can manually enter the SQL query to be
used. This query will be issued to the Database when the
session is run, overriding the SQL query generated by that
particular transformation at the mapping level.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Write the prerequisite tasks to achieve the session partition?
Do you find any difficulty while working with flat files as source and target?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can you validate all mappings in the repository simultaneously?
What is repository manager?
What is the benefit of session partitioning?
Describe expression transformation?
What are the new features of informatica 9.x at the developer level?
How to generate sequence numbers?
Explain lookup transformation is active in informatica
What are the tasks that can be performed using sq?
How do you handle two sessions in Informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How can we update a record in the target table without using update strategy?