Answer / rohan

We can use unconnected lookup multiple times in the same
mapping if required.

Answer / rascal

connected lookup is used when we need to use dynamic cache,we can return multiple o/p&need to use default values...otherwise if we want to use same lookup multiple times in the mapping then we go for un-connected lookup..In this case we can use only static cache..

Answer / poluraju

u return multiple ports you can choose connected lookup.if u want to return only one port u can choose connected or unconnected lkp.but if we want to call the same lookup multiple time with different input for single row then we choose unconnected lkp...

Answer / sandy

Connected Lookup :- When we require more than one row to be
output from the lookup.

UnConnected Lookup:- When we need only one port as output
from the lookup

Answer / rayudu

When we want to return multiple ports from a mapping we wil
use connected lookup.

An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)

regards,
rayudu

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

daily how much amount of data send to production?

4 Answers   HSBC,

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

any body can say about all versions of informatica ?how many versions ?

2 Answers  

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

4 Answers  

What are Target Options on the Servers?

1 Answers  

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

What is domain in terms of informatica?

0 Answers  

can you use flat file for repository?why?

2 Answers   TCS,