Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 17827 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
Explain pmcmd command usage in informatica
How to generate sequence numbers without using the sequence generator transformation?
How do you load only null records into target?
What does command task mean?
What are active transformations.
Define pmcmd command?
How to join three sources using joiner? Explain though mapping flow.
Write the advantages of partitioning a session?
Design a mapping to load a target table with the following values from the above source?
Where do we use mapping variables in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
If informatica has its scheduler why using third party scheduler?
What differs when we choose the sorted input for aggregator transformation?
Make a note of the quantity vaults made in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
