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
- 22879 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 |
Can we change Dynamic to Static or Persistent cache? If so what happens?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Design a mapping to load a target table with the following values from the above source?
Explain about the concept of mapping parameters and variables ?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
What do you mean by enterprise data warehousing?
What is a command that used to run a batch?
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?
"Change cache" in Informatica ?
can we use mapplet as starting n ending object in mapping
What are the different components of powercenter?
how to get the first row without using rank t/r?
Teradata 
