Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What are the designer tools for creating transformations?

1127


how many types of dimensions are available in informatica?

1111


What is aggregate cache in aggregator transformation?

1153


What is an active transformation?

1119


What is the difference between STOP and ABORT options in Workflow Monitor?

1269


How can you increase the performance in joiner transformation?

1206


How to generate sequence numbers?

1098


How to extract the informatica rejected data?

1229


What is the difference between informatics 7x and 8x and what is latest version?

1093


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1999


what is mean by complex business rule ?

2173


Write the unconnected lookup syntax and how to return more than one column.

1120


What do you understand by a term domain?

1135


Why do you use Mapping Parameter and mapping variable?

1776


How to use procedural logic inside infromatica?

1255