How can we get multiple output values using an unconnected
lookup transformation?

Answers were Sorted based on User's Feedback



How can we get multiple output values using an unconnected lookup transformation?..

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

How can we get multiple output values using an unconnected lookup transformation?..

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

Post New Answer

More Informatica Interview Questions

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  


i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,


what is a transforamation?

5 Answers  


What is Code Page Compatibility?

1 Answers  


Repository user profiles

0 Answers  


To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  


In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  


how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,


i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,


Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,


Categories