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
Explain what transformation and how many are there in informatica?
How to generate sequence numbers?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is lookup transformation?
What is a snowflake schema?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How many numbers of sessions can one group in batches?
What is Session and Batches?
What is standalone command task?
How are indexes created after completing the load process?
What is rank transformation?
What will be the approach?
What is target load order?
What does role playing dimension mean?
Explain lookup transformation in informatica