Answer / meenal

In Informatica 9.1 Lookup is active because of property - "Lookup policy on multiple match", this can be chosen as first, last, any value or all values. So now we can configure the Lookup transformation to return all rows that match a lookup condition. Hence, a Lookup transformation is an active transformation when it can return more than one row for any given input row.

However this property is available only for connected lookup, unconnected lookups are still passive.

Answer / surendra kumar

Hi,

Lookup is both "Active" as well as "Passive"

Till informatica 8 it was only passive because one of its property "Lookup Policy on Multiple Match" has options of:
i)any values
ii)first values
iii)last values
iv)report error
So for each input record it will produce one output record either any corresponding matching value or Null. But number of Input row is equal to number of output row.

But from Informatica 9 onwards there is one addition in the option of "Lookup Policy on Multiple Match" is:
"Use All Values"
using this property one input row can give multiple output rows i.e number of input rows is not equal to number of output rows.

Thanks & Regards
Surendra Kumar

Answer / priyanka

hi
Suppose if we have 3 records with same key value, only then
first, last are considered. Based on given preference, if
it is first, it will consider the record which comes first.
If it is last, it considers the matched record which comes
by the end of that session.If there are no duplicate
records then,if there is a matched record it will return
the respective data for that record else with return NULL.
But, as it tracks all the records with some result i.e
either with its value or NULL, we consider it as passive
transformation

Answer / vidyasagar

@Srinivas

after condition satisfies it does'nt reduces rows

say

src_table Lookup_table Result
10 10 10
20 Null
30 Null

number of sources=3 and result also 3 rows hence

Lookup is a passive transformation :)

Regards:
Vidyasagar

Answer / jay

There is an option in the properties of Lookup transformation in which we could select "First", "Any" or "Last" which would may give only one row.

So it is Active transformation.

Answer / vidyasagar

Dude Jay,

its a passive transformation

in yo case eventhough you are selecting first last or any
it will select the selected column and null for the rest of
the rows so the number of rows remains same , hence its the
passive transformation.

one more thing you can by-pass the lookup so only a passive
txn can be by-passed.

if anyone have any queries lemme know :)

Answer / nsiddardh

Both connected ans unconnected look-up transformations are
passive.because the input rows supplied to the look-up are
equal to output rows.so we call look-up transformation is
passive.

Answer / srinivas

hi
experts, i suppose to eswar 's answers
lookup transformation is passive transformation .ie it cant
reduce rows after condition satisfy or nt

Answer / eswar

Both Lookup transformations are passive

"A passive transformation does not change the number of
rows that pass through it, such as an Expression
transformation that performs a calculation on data and
passes all rows through the transformation."

And

"An active transformation can change the number of rows
that pass through it, such as a Filter transformation that
removes rows that do not meet the filter condition."

Therefore, the Lookup transformations work as passive but
not as active transformations.

What are two types of processes that informatica runs the session?

2 Answers  

What is informatica powercenter repository?

0 Answers  

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

where to select code page option?

2 Answers   TCS,

what is polling?

1 Answers   Informatica,

How the Informatica Server reads perameter file?

1 Answers