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

Explain the difference between a data warehouse and a data mart?

1107


What is joiner transformation in informatica?

1096


How to update or delete the rows in a target, which do not have key fields?

1219


Under which circumstances, informatica server creates reject files?

1136


What is the use of an aggregator cache file?

1245


State the limitations where we cannot use joiner in the mapping pipeline?

1104


What are the data movement modes in informatica?

1206


What is workflow? What are the components of workflow manager?

1230


What is a rank transform?

1144


In how many ways we can create ports?

1154


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10312


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3921


What are pre and post-session shell commands?

1380


What is the difference between stop and abort in informatica

1141


Differences between version 7.x and 8.x.

1939