1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How can we get multiple output values using an unconnected
lookup transformation?

Question Posted / umaadevi

Answers were Sorted based on User's Feedback



How can we get multiple output values using an unconnected lookup transformation?..

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

How can we get multiple output values using an unconnected lookup transformation?..

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

Post New Answer

More Informatica Interview Questions

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

What is target update override

2 Answers   CTS,

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

Explain factlessfact table with scenario

1 Answers   HCL,




Explain the difference between mapping parameter and mapping variable?

0 Answers  

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

Can you use one mapping to populate two tables in different schemas

2 Answers  

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

what is degenerated dimension?

1 Answers   IBM,

What is incremental aggregation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories