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

Yes, Lookup Condition means is join COndition...By default,
it will give Normal joins..The different types of Join
conditions are =,!=,<,<=,>,>=

Please correct if I am wrong...

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

COM components can be used in Informatica

1881


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6760


Differences between connected and unconnected lookup?

610


Enlist the differences between database and data warehouse.

557


How can informatica be used for an organization?

653






what is index?how it can work in informatica

1590


Explain the features of connected and unconnected lookup.

548


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

605


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

611


How to generate sequence numbers?

622


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9172


What are the new features of informatica 9.x in developer level?

568


What is rank transformation in informatica

693


Which is the t/r that builts only single cache memory?

716


What is persistent lookup cache?

607