Interested to Buy Any Domain ? << Click Here >> for more details...
How can we get multiple output values using an unconnected
lookup transformation?
- 2 Answers
- 16707 Views
- TCS, I also Faced
- E-Mail Answers
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
To import the flat file definition into the designer where should the flat file be placed?
Explain transaction control transformation in informatica
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What do think which one is the better joiner or look up?
What is dynamic cache?
Define the various join types of joiner transformation?
How to join three sources using joiner?
Can informatica load heterogeneous targets from heterogeneous sources?
How to extract sap data using informatica? What is abap? What are idocs?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain incremental aggregation in informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
update strategy transformation in informatica
How to generate sequence numbers?
How to do unit testing in informatica?
