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

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1011


What is meant by a domain?

1096


What is session task and command task?

1213


What is a node in Informatica?

1012


In informatics server which files are created during the session rums?

1091


list out all the transformations which use cache?

1144


What does role playing dimension mean?

1016


Different qualification between a related rotate toward the sky and isolates look upward?

948


What are active transformations.

1614


What is incremental aggregation?

1040


can anyone suggest best free Talend data integration training online

1648


Tell me about Propagate functions in informatica

893


Target increases every day even though no new record was inserted

1529


What are the performance considerations when working with aggregator transformation?

1119


What are the main features of Oracle 8i with context to datawarehouse?

2070