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
- 61315 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 are the uses of etl tools?
Tell me about MD5 functions in informatica
What is the scenario which compels informatica server to reject files?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a filter transformation and why it is an active one?
What are the different transaction levels available in transaction control transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What do mean by local and global repository?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How can one identify whether mapping is correct or not without connecting session?
How does the aggregator transformation handle null values?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Slowly changing dimensions, types and where will you use them
How we can use union transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
