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 to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

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,

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

what is confirmed fact?

2 Answers  

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

0 Answers   CTS,

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,