Can we use unconnected lookup as dynamic lookup?
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 |
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the types of maping in Getting Started Wizard?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
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 ??
How to configure mapping in informatica?
can we see default group,when we use router?if yes how?
What are the different caches used in informatica?
Write the advantages of partitioning a session?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
how to load duplicate row in a target
can anyone explain me about retail domain project in informatica?