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 ?
- 6 Answers
- 21936 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vivek
as per my understanding.. lkp is always behave like left
outer join..it ll give you all matched records as well as
ummatched records which is not present in base table...and
those unmatched records is ll be null in case of
unconnected lkp trn.....
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / venkat
here lkp transformation is perform left outer join only.
it will display matching and non matching records,but in
case of non matching(while using conn lkp)records return
default value.while using unconn lkp returns null value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / 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 |
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 |
Answer / 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 |
What is an aggregator transformation? it is active why cant it be passive explain?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
scenario where i can use only concurrent execution of workflow.
What are active transformations? Name them.
What are the basic needs to join two sources in a source qualifier?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
explain about session partitions ?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What is a sorter transformation?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
How informatica recognizes mapping?
Teradata 
