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
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the new features of informatica 9.x in developer level?
Differentiate between router and filter transformation?
What is parallel processing in informatica?
Define mapping and session?
How an expression transformation differs from aggregator transformation?
What are active and passive transformations?
permutations of mapplet
To import the flat file definition into the designer where should the flat file be placed?
What is a surrogate key?
what is mean by complex business rule ?
Differences between version 7.x and 8.x.
what is diff b/t sorter t/r and agg have the option sorter property...
How many input parameters can exist in an unconnected lookup?
How do you promote a non-reusable transformation to reusable transformation?