How can we get multiple output values using an unconnected
lookup transformation?
- 2 Answers
- 15420 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 |
define galaxy repository in informatica
scenario where i can use only concurrent execution of workflow.
How can you run a session without using server manager?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What are two types of processes that informatica runs the session?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
i have 2 session s1 execute s2 load first session fail what is the reason?
what is the size of u r source(like file or table)?
how to join the two flatfiles using the joiner t/r if there is no matching port?
What will be the approach?
what is junk dimension
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
Teradata 
