lookup is passive y can't it be active?
let us say i have some records in my source like
101,rohit,1000
101,rohit,1000
102,kumar,2000
like wise
now as it is having multiple matches i return only
first,last value it can't return bouth the values
that means lookup is acting as select distinct right by
default what means it is active?

Answers were Sorted based on User's Feedback



lookup is passive y can't it be active? let us say i have some records in my source like 101..

Answer / sarthak

Your Question is wrong......

this data belongs to Source table or look up table..

Multiple match principle comes in lookup table(not in source
table)..
if no. of rows in source table that connected to lookup t/f
is 3,then the output of lookup t/f is 3 rows...

it will not decrease

Is This Answer Correct ?    2 Yes 1 No

lookup is passive y can't it be active? let us say i have some records in my source like 101..

Answer / pune.rohitsharma

well my ans as we are doing look-up on source and we are
getting the records from the DB not from any other t/r
so that's y it is passive.

Is This Answer Correct ?    5 Yes 5 No

lookup is passive y can't it be active? let us say i have some records in my source like 101..

Answer / kannan

Simple logic here,
1) SQ passes the records one by one(logical field values
eg . customer id) to lkp up t\f.
2) Then, with this logicl field values , it looks into the
database( source \target db,provided cache is disabled in
properties), fetched the records(only look up enabled
columns) and passed to the down transformation

Is This Answer Correct ?    0 Yes 0 No

lookup is passive y can't it be active? let us say i have some records in my source like 101..

Answer / varun4db

In this case for first row with 101 id it will give random(
either first or last or any or error). And again for second
row 101 it will return any random( either first or last or
any or error).

So the count of out put row is equal to the input row. so it
is passive only.

Is This Answer Correct ?    0 Yes 0 No

lookup is passive y can't it be active? let us say i have some records in my source like 101..

Answer / akash

An active transformation handles data in groups while a
passive transformation handles them row-by-row. Lookup
handles each record one by one. So it is a passive
transformation.

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


What is update override?

1 Answers   Accenture,


4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,


which one is better performance wise joiner or look up

0 Answers   Informatica,


How many cubes create from a single model?

1 Answers  






What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


how to get the first row without using rank t/r?

7 Answers   iGate,


Describe data concatenation?

0 Answers  


What is rank transform?

0 Answers  


i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,


What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,


HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  


Categories