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

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2008


What are active and passive transformations?

1039


what is index?how it can work in informatica

1997


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2346


How can you differentiate between powercenter and power map?

1037


can we override a native sql query within informatica? Where do we do it? How do we do it?

1025


Please let me know how to make encryption and decryption with example?

1870


How many types of sessions are there in informatica.please explain them?

1130


What are the tasks that can be performed using sq?

1044


What is lookup change?

1002


How can repository reports be accessed without sql or other transformations?

1177


What is joiner change?

1100


how many types of dimensions are available in informatica?

1029


How to use procedural logic inside infromatica?

1158


How might one distinguish in the case of mapping is right or not without associating session?

1051