Is it any possible to using more than one port in Unconnected
Lookup Transformation( :LKP.LKP_Prod(Prod_GRP
,Prod_DT,Prod_TM) ) Like this? Pls explain...

Answers were Sorted based on User's Feedback



Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod..

Answer / nitish

Yes, it is possible..

Is This Answer Correct ?    4 Yes 1 No

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod..

Answer / gm

As per my knowledge u can't use like this.

u can follow below the below procedure:

first_name, second_name --->Make it one column

name =concat(first_name,second_name) or
name = first_name || second_name

Now u can use as a one port.

u get the multiple columns like the only...
Correct me If I'm wrong.

Best Regards,
GM

Is This Answer Correct ?    4 Yes 1 No

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod..

Answer / rohan

I think the question is can we pass multiple inputs to an
unconnected lookup. If I am correct, the answer is YES.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Informatica Interview Questions

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,


How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,


What is flashback table ? Advance thanks

0 Answers   Puma,


If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  


Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,






Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


Explain lookup transformation in informatica

0 Answers   Informatica,


what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,


 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


guys which is the best institute in banglore to learn informatica??

2 Answers  


what is galaxy repository?

2 Answers  


Categories