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.
- 4 Answers
- 8830 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / alekya
use a mminus query between two tables..you will get the
mismatch records.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the modules in Power Center
What are the differences between oltp and olap?
How to update source definition?
What is the difference between Active and Passive transformation?
Mention few advantages of router transformation over filter transformation.
How can repository reports be accessed without sql or other transformations?
What is standalone command task?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is the surrogate key?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the main issues while working with flat files as source and as targets ?
what are the Methods For Creating Reusable Transformations?
what is diff b/t sorter t/r and agg have the option sorter property...
In which transformation you cannot drag ports into it?
