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


Please Help Members By Posting Answers For Below Questions

How to use pmcmd utility command?

990


What is workflow manager?

1003


what is the Default Source Option For Update Strategy Transformation?

1187


Can you use flat files in Mapplets.

2622


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1882


differences between service based and product based?

1979


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6073


What is a code page?

1127


Please let me know how to make Data masking in informatica..

1679


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

1095


Explain the types of transformations?

1028


What is an expression transformation?

983


What are the different ways to implement parallel processing in informatica?

1359


What differs when we choose the sorted input for aggregator transformation?

985


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1047