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
Why update strategy and union transformations are active? Explain with examples.
Explain in detail about scd type 1 through mapping.
How do you load only null records into target?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is sequence generator transformation in informatica?
What is deployment group?
How can a transformation be made reusable?
How many number of sessions can one group in batches?
How can you define user defied event?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How are indexes created after completing the load process?
How can informatica be used for an organization?
Explain sessions?
How does a rank transform differ from aggregator transform functions max and min?