Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use unconnected lookup as dynamic lookup?
- 5 Answers
- 17656 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
What does cheating measurement mean?
can we override a native sql query within informatica? How do we do it?
What is the reusable transformation?
How can we remove the duplicates from flat file source?
What all join we can perform in LOOKUP transformation?
How does a rank transform differ from aggregator transform functions max and min?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you set a varible in incremental aggregation
What is meant by incremental aggregation?
What does refresh system mean, and what are its distinctive choice?
Performance tuning( what you did in performance tuning)
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Informatica settings are available in which file?
According to his methodology what all you need before you build a datawarehouse
can anyone suggest best free Talend data integration training online
