Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 17668 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
How to open an older version of an object in the workspace?
What are the limitations of joiner transformation?
How big was your fact table
What is a predefined event?
where to store informatica rejected data?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are pre and post-session shell commands?
What are the modules in Power Center
What is an unconnected transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Have you worked with/created Parameter file
What is flashback table ? Advance thanks
Explain dynamic target flat file name generation in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to create a non-reusable instance of reusable transformations?
