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
- 61010 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
What is meant by target load plan?
How do you take back up of repository?
Write the program through which the records can be updated?
What do think which one is the better joiner or look up?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How will the document be delivered to me?
Explain the types of lookup transformation?
Write the unconnected lookup syntax and how to return more than one column.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the cumulative sum and moving sum?
tell me about your project functionality
can anyone suggest best free Talend data integration training online
Can you use flat files in Mapplets.
What are some examples of informatica etl programs?
What are the new features of informatica 9.x in developer level?
