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


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

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

How to load a relational source into file taget?

2 Answers  


Useful UNIX commands regular/frequently used

1 Answers   Deloitte,


i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,


Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,


Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  


What is workflow manager?

0 Answers  


hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,


What is a router transformation?

0 Answers  


how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  


explain about session partitions ?

1 Answers  


Why we use lookup transformations?

1 Answers  


How do you handle two sessions in Informatica

0 Answers   Informatica,


Categories