Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

In which circumstances that informatica server creates Reject files?

2 Answers  


What is the session task and command task?

0 Answers  


what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  


I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,


What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  


What is repository manager?

0 Answers  


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


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.

3 Answers   TCS,


What is complex mapping?

0 Answers  


how can import the data from the flat files?

2 Answers  


What is aggregate cache in aggregator transformation?

0 Answers   Informatica,


Categories