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

can a port in expression transf be given the name DISTINCT

3 Answers  

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

What did you do in source pre load stored procedure

1 Answers  

What is a router transformation?

0 Answers  

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

How do you handle decimal places while importing a flatfile into informatica?

1 Answers  

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,