how lookup is acting as both active and passive ?
how is it possitble?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 43 Yes | 0 No |
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
Is This Answer Correct ? | 39 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 4 No |
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
Is This Answer Correct ? | 7 Yes | 12 No |
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.
Is This Answer Correct ? | 11 Yes | 16 No |
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 :)
Is This Answer Correct ? | 2 Yes | 8 No |
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
Is This Answer Correct ? | 3 Yes | 11 No |
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.
Is This Answer Correct ? | 7 Yes | 26 No |
How will you update the first four rows and insert next four rows in a mapping?
how to load rows into fact table in data warehouse
how to create user defined function (udf) in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How will you display "Mr" for male & "Mrs" for female in target table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Is it possible to update the target table with PK?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What does update strategy mean, and what are the different option of it?
What is workflow monitor?