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 a diff between joiner and lookup transformation

Answer Posted / jayash

joiner transformation does not match for null values where
as lookup transformation matches for null values
joiner transformation supports only equality operator in
condition of join where as lookup transformation can support
<=,>=,=,!= in the lookup condition

Is This Answer Correct ?    47 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of transformations available in informatica?

936


Explain the types of transformations?

1005


What is a filter transformation and why it is an active one?

906


How would you join a node to the already existing domain?

1066


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2121


Define mapplet?

962


What is target load order?

1186


Differentiate between Load Manager and DTM?

2093


Repository user profiles

1713


What are the transformations that are not supported in mapplet?

956


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1727


wat are deployement groups in informatica, how it will be used for developers

1668


Design a mapping to load a target table with the following values from the above source?

1285


How to generate sequence numbers using expression transformation?

1026


Explain Dataware house architecture .how data flow from intial to end?

2526