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

  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

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

Name the different lookup cache(s)?

0 Answers  

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

Explain the types of transformations?

0 Answers  

What are the out put files that the informatica server creates during the session running?

2 Answers  

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

Scheduling properties,whats the default (sequential)

0 Answers  

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories