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 |
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
Diff b/w ShortCut and reusabel Object ?
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?
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?
what is a transforamation?
What is Code Page Compatibility?
Repository user profiles
To provide support for Mainframes source data,which files r used as a COBOL files
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.........?
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
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.