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

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

What is confirmed dimension with scenario

1 Answers   HCL,

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

In development project what is the process to follow for an etl developer from day1

0 Answers  

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,




How to import oracle sequence into Informatica?

3 Answers   Satyam,

What are the reusable transforamtions?

2 Answers  

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

What is meant by active and passive transformation?

0 Answers  

What is a surrogate key?

0 Answers  

What is standalone command task?

0 Answers  

For more Informatica Interview Questions Click Here
Categories