Interested to Buy Any Domain ? << Click Here >> for more details...
How can we get multiple output values using an unconnected
lookup transformation?
- 2 Answers
- 16620 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 |
What is the difference between Normal load and Bulk load?
What is the command used to run a batch?
How to recover the standalone session?
As union transformation gives UNION ALL output, how you will get the UNION output?
what is the size of u r source(like file or table)?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How union transformation is active ?
I want load the data into target with out 1st and last record.
Scheduling properties,whats the default (sequential)
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the types of data that passes between informatica server and stored procedure?
what is the purpose of surrogate key and diff between primary key&surrogate key
Teradata 
