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 status code?

2 Answers  

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

Scheduling properties,whats the default (sequential)

0 Answers  

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

what is the exact meaning of domain?

3 Answers  

How to delete the data in the target table after loaded.

3 Answers   TCS,

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

What is the difference between view and materialised view?

6 Answers