How can we get multiple output values using an unconnected
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 do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
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
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Which is better performance wise database or file?How?
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
Flat file heaving 1 lack records and I want to push 52000 records to the target?
How an expression transformation differs from aggregator transformation?
Explain your project of banking domian.
what is the difference between mapplet & stored procedure?
Write the unconnected lookup syntax and how to return more than one column.
how eliminate the duplicates in flat file with out using sorter ,aggregater