source table A having 100000 records. and target B table
having 100000 records. now iam updating B records using update
query. i don't know which record is update in target. write a
sql query get all updated records from target table B.
Answer Posted / srini
In this case check Target table should have Record update
timestamp along with Insert time stamp
Other wise Check the max time stamp it will help.
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
How to use pmcmd utility command?
What is workflow manager?
what is the Default Source Option For Update Strategy Transformation?
Can you use flat files in Mapplets.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
differences between service based and product based?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a code page?
Please let me know how to make Data masking in informatica..
Is it possible to use a client with different version than that of its Informatica server?
Explain the types of transformations?
What is an expression transformation?
What are the different ways to implement parallel processing in informatica?
What differs when we choose the sorted input for aggregator transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?