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
How to join three sources using joiner?
Describe data concatenation?
What is meant by a domain?
Design a mapping to load a target table with the following values from the above source?
Write the prerequisite tasks to achieve the session partition?
What is the reusable transformation?
Why union transformation is an active transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what is the difference between informatica6.1 and infomatica7.1
What does “tail –f” command do and what is its use as an Informatica admin.
Define joiner transformation?
What is the use of target designer?
What is meant by active and passive transformation?
Explain the different lookup methods used in informatica?
What is difference between a gateway node and worker node?