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 ?
- 6 Answers
- 22970 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 |
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
What are the different threads in DTM process?
why we use informatica in our project?
What are the restrictions of union transformation?
How can we eliminate duplicate rows from flatfile,explain?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
How to elaborate powercenter integration service?
What are the session parameters?
What is olap (on-line analytical processing?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
Teradata 
