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

LOOKUP Condition is nothing but a Join condition?
What type of join condition it,by default ?
Using the LookUP Condition How many types of relational
conditions we can make ?

Answer Posted / krishna

lkp is passive tr beacuse it returns 0 when condition doesn't matches .
If multiple conditions match in lkp returns first & last values.
Lkp supports Equi & non-Equi joins.
By default it is left outer join.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to join three sources using joiner?

1029


Describe data concatenation?

1005


What is meant by a domain?

1078


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

1285


Write the prerequisite tasks to achieve the session partition?

1072


What is the reusable transformation?

1006


Why union transformation is an active transformation?

993


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2277


what is the difference between informatica6.1 and infomatica7.1

2182


What does “tail –f” command do and what is its use as an Informatica admin.

1029


Define joiner transformation?

986


What is the use of target designer?

981


What is meant by active and passive transformation?

1031


Explain the different lookup methods used in informatica?

972


What is difference between a gateway node and worker node?

1064