Can we use unconnected lookup as dynamic lookup?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / rakeshm4119@gmail.com

5 Answers
15909 Views
ITC Infotech, TCS, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we use unconnected lookup as dynamic lookup?..

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.

Is This Answer Correct ?

13 Yes

0 No

Can we use unconnected lookup as dynamic lookup?..

Answer / suresh

Is This Answer Correct ?

14 Yes

7 No

Can we use unconnected lookup as dynamic lookup?..

Answer / rakesh

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

Is This Answer Correct ?

2 Yes

0 No

Can we use unconnected lookup as dynamic lookup?..

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.

Is This Answer Correct ?

1 Yes

0 No

Can we use unconnected lookup as dynamic lookup?..

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.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer