Answer / dev

Unconnected lookup will return one port only. But dynamic
lookup will return more than one port and it update and
insert the targt while session runs.

Answer / suresh

no

Answer / rakesh

thanks suresh, and can any one explain why(the reason)?

Answer / ajay

In addition to above. When we enabled the dynamic cache the
return port is disabled. And in un-connected lookup lookup
must return a value.

Answer / amit

With unconnected lookup - we can call unlkp zero times or n-times into our mapping.

With dynamic cache - the Integration Service insert or update rows into the cache or leaves it unchanged depending on lookup condition.

Suppose if the dynamic cache option is available in unconnected lookup, the Integration Service couldn't determine which is correct call (unconnected lookup can call n-times) for update/insert rows into lookup cache. Hence, the Informatica does not support Dynamic Lookup Cache with Unconnected Lookup by default to avoid this ambiguity.

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

why do u use shortcuts in informatica.?

4 Answers   iFlex,

What is A cache?

2 Answers  

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

How can you generate reports in informatica?

0 Answers  

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

Insert else update option in which situation we will use

4 Answers   HCL,

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers