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 source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

What is Index Caches size?

0 Answers   Informatica,

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  

What is active and passive transformation?

10 Answers  

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

What are connected or unconnected transformations?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories