WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
Answer Posted / praveen kumar pendekanti
In the case of source qualifier when we use sql override
opition we will get query with our alias name and when we
user update transformation override when we enter update
override we will get column names with alias name
In update transformation order by clause is default that is
not in sql over ride(According to my knowledge)
If i am wrong plz correct me to my mail-id.....
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is joiner change?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
what is the difference between informatica6.1 and infomatica7.1
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Enlist the various types of transformations.
what is SDLC way of code development?
What is the difference between Active and Passive transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to open an older version of an object in the workspace?
What is the format of informatica objects in a repository?
update strategy transformation in informatica
What is a stored procedure transformation?
What is an expression transformation in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?