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 / srinu
Hi Kalyan ,,Thanks,,
Lookup Trans is a Passive,
It wil return all source rows,Match or Unmatch,,,
Source column Checks with LookupCache column , wright ?
Return port may be Value or null.
Normaljoin wil Returns all Match rows only.
May be your Answer not Correct.
If any corrections 'srinu.srinuvas@gmail.com'
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is informatica?
What is the fact table?
What is Cognos script editor?
What do think which one is the better joiner or look up?
What is sequence generator transformation in informatica?
Enterprise data warehouse your projects phase by phase explain?
What are the new features of Power Center 5.0?
In development project what is the process to follow for an etl developer from day1
What is an expression transformation in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is target designer and target load order?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is meant by LDAP users?
Explain how many types of dimensions are available in informatica?