Interested to Buy Any Domain ? << Click Here >> for more details...
how lookup is acting as both active and passive ?
how is it possitble?
- 9 Answers
- 60839 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
can u give example for factless fact table
What is substr in informatica?
How many numbers of sessions can one group in batches?
What is a filter transformation and why it is an active one?
State the limitations where we cannot use joiner in the mapping pipeline?
What is a node in Informatica?
What are the main features of Oracle 8i with context to datawarehouse?
Enlist some properties of sessions.
Define filter transformation?
How to go to the older version for a mapping?
How can we create index after completion of load process?
How to join three sources using joiner? Explain though mapping flow.
What do you mean by worklet?
What is rank index in rank transformation?
How do you update the records with or without using update strategy?
