Can we use unconnected lookup as dynamic lookup?
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
How to extract sap data using informatica? What is abap? What are idocs?
What is different between the data warehouse and data mart?
Which transformation should we use to normalise the COBOL and relational sources?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
difference between informatica 8.1.1 and 8.6
What happens when a session fails and you click on recover?
Explain Dataware house architecture .how data flow from intial to end?
What is the procedure for creating independent data marts from informatica 7.1?
What is a dimensional model?
How can we use mapping variables in informatica? Where do we use them?
What does cheating measurement mean?
What is a filter transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is event and what are the tasks related to it?
How many ways are there to create ports?