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

what is the diff b/w union and joiner and lookup?

Answer Posted / maruthi

union-can join two tables without common port
joiner-can join any two hetrogenous sources,but common port
is necessary.
lookup-we can join two tables by using sql over-ride,apart
from that we can check wether the row is already existing
or not.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sequence generator transformation in informatica?

1058


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1042


What are the uses of etl tools?

1111


Explain about Informatica server process that how it works relates to mapping variables?

1047


What is dimensional table? Explain the different dimensions.

1157


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2041


Which transformation is needed while using the Cobol sources as source definitions?

1157


Explain the tuning lookup transformation - informatica

979


What is session task and command task?

1264


hi real timers . iam waiting for ur reply regarding ETL TESTING

2256


What all are steps in up gradation of Informatica server?

1033


What is status code in informatica?

1005


What is blocking transformation?

1126


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1774


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1244