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.

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

how can i invoke pmcmd in command line prompt

1 Answers  

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

Can you copy the session to a different folder or repository?

1 Answers  

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

What is standalone command task?

0 Answers  

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,