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 / ankur saini er.ankur861@gmail.

hi...i think this cannt be done without an audit columns ..
a date or batch id etc..

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does a rank transform differ from aggregator transform functions max and min?

1141


Explain where to store informatica rejected data? How to extract the informatica rejected data?

947


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2018


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

1123


What is rank transformation?

927


Define sessions in informatica etl?

962


What is union transformation?

905


In how many ways we can create ports?

1064


What is the command used to run a batch?

993


what are the deliverables?in your project?

2084


What is the maplet?

1038


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1949


Describe data concatenation?

1004


Why sorter is an active transformation?

1125


scenario where i can use only concurrent execution of workflow.

3061