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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
server hot-ws270 is connect to Repository B. What does it mean?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Performance tuning( what you did in performance tuning)
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is workflow? What are the components of the workflow manager?
What is meant by a domain?
Partition, what happens if the specified key range is shorter and longer
How we can create indexes after completing the loan process?
update strategy transformation in informatica
Describe the impact of several join conditions and join order in a joiner transformation?
How do you load unique records into one target table and duplicate records into a different target table?
Scheduling properties,whats the default (sequential)
What is the maplet?
Which transformation is needed while using the Cobol sources as source definitions?