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

What are the different tools in workflow manager?

1 Answers  

How many number of sessions can one group in batches?

0 Answers  

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

Define pmcmd command?

0 Answers  

When do you use sql override in a lookup transformation?

0 Answers  

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,