Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 16015 Views
- ITC Infotech, TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is the dashbords?
What aer the out put files that the informatica server creates during the session running?
what are the different types of transformation available in informatica and what are the mostly used ?
What are the reusable transforamtions?
what is datamart
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is A complex mapping?
How can we create index after completion of load process?
where actually the usage of push down optimization happens...
is it possible to index the data in cache of lkp transformation ?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What is substr in informatica?
Teradata 
