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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / sowjanya

Answer Posted / sowjanya

If the tables are from two different databases you should
use JOINER to join them.

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

3859

What are the tuning techniques you applied during your last project

2018

Separate from an archive server and a powerhouse?

953

What are the different lookup cache(s)?

1107

What is a dimensional model?

973

What does command task mean?

1134

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2849

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1919

Slowly changing dimensions, types and where will you use them

1704

What are the different types of olap? Give an example?

1045

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2033

In development project what is the process to follow for an etl developer from day1

1708

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2238

What is an unconnected transformation?

1077

what is unit testing?tell me proceedure

2213