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...

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2423


Please let me know how to make encryption and decryption with example?

1460


What is an expression transformation?

586


What are the types of schemas we have in data warehouse.

526


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1614






What does “tail –f” command do and what is its use as an Informatica admin.

627


What are the types of lookup transformation?

627


What is the use of transformation?

569


What is an active transformation?

643


What is meant by lookup transformation?

608


what is size of u r database?

1844


What are the tasks that can be performed using sq?

609


Difference between Data and Index Caches?

648


Design time, run time. If you don't create parameter what will happen

1422


In informatica workflow manager, how many repositories can be created?

776