Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 17691 Views
- ITC Infotech, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Differentiate between joiner and lookup transformation?
Explian the Process of deployment groups in informatica
Explain sessions. Explain how batches are used to combine executions?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain the types of transformations?
what is degenerated dimension?
What is meant by a domain?
Explain in detail about scd type 1 through mapping.
What are the different options available for update strategy?
Differentiate between a repository server and a powerhouse?
Is it possible to revert a global repository to local one and why?
How union transformation is used?
How many ways are there to create ports?
difference between informatica 8.1.1 and 8.6
Explain why we use partitioning the session in informatica?
