Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 34247 Views
- Target, I also Faced
- E-Mail Answers
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 a repository? And how to add it in an informatica client?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How many numbers of sessions can one group in batches?
How to extract the informatica rejected data?
What is a sequence generator transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is meant by a domain?
What is an aggregator transformation?
What are junk dimensions?
Define Pmrep command?
What is complex mapping?
Is it possible to revert a global repository to local one and why?
How to do the error handling of if ur source is flatfiles?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is lookup change?
