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 / hollister

The key coluns that are common in both tables are to be
considered and compare each field in both tables. If there
is any change in any of the column in table B then it is
the updated column.

Is This Answer Correct ?    0 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does command task mean?

1134


Is it possible to use a client with different version than that of its Informatica server?

1126


COM components can be used in Informatica

2379


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1138


what is song in infrmatica...?

2226


define galaxy repository in informatica

2218


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2053


Which transformation is needed while using the Cobol sources as source definitions?

1161


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2056


Is there any way to read the ms excel datas directly into informatica?

1018


can anyone suggest best free Talend data integration training online

1688


What is a predefined event?

1086


What is the use of transformation?

990


What are the tasks that can be performed using sq?

1084


 Informatica Checkpoints

3321