Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,


on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,


HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


Which is better performance wise database or file?How?

2 Answers   TCS,






If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,


Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  


How an expression transformation differs from aggregator transformation?

0 Answers  


Explain your project of banking domian.

0 Answers   Cap Gemini,


what is the difference between mapplet & stored procedure?

1 Answers  


Write the unconnected lookup syntax and how to return more than one column.

0 Answers  


how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,






Categories