How can we get multiple output values using an unconnected
lookup transformation?
Answer Posted / viswanath
Lookup transformation from Informatica 9x version can be
configured as an Active Transformation...
To use this option, while creating the transformation, we
must configure the Lookup transformation property "Lookup
Policy on Multiple Match" to Use All Values. Once created
we cannot change the mode between passive and active. When
ever the Lookup policy on multiple match attribute is set
to Use All Values. The property becomes read-only.
However, this is not possible for an Unconnected Lookup. We
may have to use the same old procedure of returning single
value by conctinating the required fields by a delimiter..
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Tell me about MD5 functions in informatica
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Which means the first record should come as last record and last record should come as first record and load into the target file?
Implementation methodology
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What does reusable transformation mean?
What is a repository manager?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What if the source is a flat-file?
How to use procedural logic inside infromatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is informatica etl tool?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Is there any way to read the ms excel datas directly into informatica?
What is a passive transformation?