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 meant by pre and post session shell command?
What are junk dimensions?
What is the benefit of session partitioning?
What are the tasks that can be performed using sq?
How to extract the informatica rejected data?
Can we override a native sql query within informatica?
What are the types of data warehouses?
Explain target update override in informatica
Differences between version 7.x and 8.x.
what are factless facts? And in which scenario will you use such kinds of fact tables.
Design a mapping to load a target table with the following values from the above source?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the advantages of using informatica as an etl tool over teradata?
What does command task mean?
What is the command used to run a batch?