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 / janani

We can use lookup Transformation and expression to compare
the data

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1962


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1210


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1674


What is powercenter on grid?

1223


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

1326


What are the tasks that source qualifier perform?

1142


What is expression transformation?

1144


Can we change Dynamic to Static or Persistent cache? If so what happens?

2248


Differentiate between a database and data warehouse?

1187


Write the unconnected lookup syntax and how to return more than one column.

1147


Describe data concatenation?

1121


How many ways a relational source definition can be updated and what are they?

1061


Explain your project of banking domian.

1689


What is an expression transformation in informatica?

1087


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1208