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 all are steps in up gradation of Informatica server?

1047


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280


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

1922


What is informatica etl tool?

1000


How are indexes created after completing the load process?

1649


Tell me about Propagate functions in informatica

923


what are the deliverables?in your project?

2152


Clarify the utilization of aggregator cache record?

1004


differences between service based and product based?

2020


What is Cognos script editor?

4238


How do you change a non-reusable transformation to reusable transformation?

999


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1284


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1281


How to generate or load values in to the target table based on a column value using informatica etl tool.

1080


Explian the Process of deployment groups in informatica

1062