How can we get multiple output values using an unconnected
lookup transformation?
Answers were Sorted based on User's Feedback
Answer / atul pitroda
This should be simple enough to concate the values with
delimeters and deconcate at the receiver end.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / 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 |
How to load a relational source into file taget?
Useful UNIX commands regular/frequently used
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
Can informatica load heterogeneous targets from heterogeneous sources?
What is workflow manager?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
What is a router transformation?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
explain about session partitions ?
Why we use lookup transformations?
How do you handle two sessions in Informatica