Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9742 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
Differentiate between Load Manager and DTM?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to do unit testing in informatica?
On which transformations you created partitions in your project?
Enlist some properties of sessions.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How do you promote a non-reusable transformation to reusable transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain the aggregator transformation?
What are active and passive transformations?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Where can we find the throughput option in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
