1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 ?

Question Posted / srinu

Answers were Sorted based on User's Feedback



LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Usin..

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

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Usin..

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

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Usin..

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

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Usin..

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

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Usin..

Answer / 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

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Usin..

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

Post New Answer

More Informatica Interview Questions

can anyone suggest best free Talend data integration training online

0 Answers  

What are the Advantages of de normalized data?

3 Answers  

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

8.what is mapplet ?give example?

2 Answers  




Why use the lookup transformation ?

2 Answers   Informatica,

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

EXL informatica Questions

0 Answers  

Target increases every day even though no new record was inserted

0 Answers   Accenture,

What are the new features of informatica 7.1?

2 Answers  

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

For more Informatica Interview Questions Click Here
Categories