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 / krithi

Using the Lookup Condition , we can only compare values
between two columns. If the data matches it returns the
default value and NULL if the data doesn't match.

We can compare using the following operators :

1) =
2)!=
3)< or <=
4)> or >=

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of aggregator cache file?

1233


What is domain in terms of informatica?

994


Differences between connected and unconnected lookup?

1201


Differentiate between a repository server and a powerhouse?

1099


What does role playing dimension mean?

1032


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

2042


What is meant by active and passive transformation?

1109


What does cheating measurement mean?

1031


Explain the shared cache and re-cache?

1094


What is Data Caches size?

1072


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1096


What do think which one is the better joiner or look up?

1187


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2220


Difference between Target-based loading and constraint-based loading?

983


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2137