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

two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?

Answer Posted / shobana

Joiner transfomation is used to join two differned soures
from the same database. Lookup transformation and
expressions(if needed) can be used to compare data from two
different two differebt types of sources.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pmcmd command?

1123


What do you mean incremental aggregation?

1077


While migrating the data from one environment to another environment how would you manage the connections?

1090


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1128


What are Dimensional table?

1057


How can a transformation be made reusable?

1171


When do you use sql override in a lookup transformation?

1099


How you can differentiate between connected lookup and unconnected lookup?

1063


What is InformaticaPowerCenter?

1136


What is a difference between complete, stop and abort?

1083


State the differences between sql override and lookup override?

1209


Tell me about MD5 functions in informatica

929


How do you load only null records into target?

1216


Define update strategy?

1230


How can you validate all mappings in the repository simultaneously?

1371