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 / rajesh myle

1. Lookup T/R supports Non-Equi Joins. Where as Joiner
T/R does not support the Non Equi Joins. (Joiner T/R
supports only Equi Joins(i.e. ‘=’))

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1092


Write the different tools in the workflow manager?

995


What are the types of presistent cache in look up tr.

2009


What is a standalone command task?

1142


What is meant by lookup transformation?

1034


Explain sql transformation in script mode examples in informatica

1048


What is the use of code page?

1013


Explain why we use partitioning the session in informatica?

1008


Design time, run time. If you don't create parameter what will happen

1797


What is the commit type if you have a transaction control transformation in the mapping?

973


How can a transformation be made reusable?

1079


How you can differentiate between connected lookup and unconnected lookup?

1009


How do you load unique records into one target table and duplicate records into a different target table?

1166


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1928


What are the designer tools for creating transformations?

1050