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
Define Pmrep command?
Did u used latest transformations of 8.6.0? for what?
What is flashback table ? Advance thanks
Slowly changing dimensions, types and where will you use them
Explain Dataware house architecture .how data flow from intial to end?
What do mean by local and global repository?
How would you copy the content of one repository to another repository?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the cumulative sum and moving sum?
What is the use of an aggregator cache file?
Why is sorter an active transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is DR strategy for Informatica project?
What is a grid in Informatica?
What are the components of the workflow manager?