Interested to Buy Any Domain ? << Click Here >> for more details...
How can we get multiple output values using an unconnected
lookup transformation?
- 2 Answers
- 16583 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the sequence generator transformation in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
In how many ways we can create ports?
complex mapping ur project u r invlve can u explain and give real time example give me ?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Tell me about Propagate functions in informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Where is metadata stored?
Enlist the advantages of informatica.
Design time, run time. If you don't create parameter what will happen
Explian the Process of deployment groups in informatica
What is a mapplet/worklet in informatica?
