Interested to Buy Any Domain ? << Click Here >> for more details...
How can we get multiple output values using an unconnected
lookup transformation?
- 2 Answers
- 16582 Views
- TCS, I also Faced
- E-Mail Answers
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 can one eliminate dupliacte data with out using distinct option?
what is the purpose of surrogate key and diff between primary key&surrogate key
What is olap (on-line analytical processing?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
what is the use of Java Transformation in Informatica 8.x?
Slowly changing dimensions, types and where will you use them
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
if we have a delimiters at unwanted places in a flat file how can we over come those.
what is galaxy repository?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Teradata 
