Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose we are using a Dynamic Lookup in a Mapping and the commit
Interval set for the tgt is 10000. Then how does the data get
committed in the lookup if there were only 100 roows read from
the src and the dynamic lookup dint have the 100th row in it?
- 3 Answers
- 17655 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
Answer Posted / imran
The dynamic lookup cache will be updated in real-time as each row is processed, independent of the target commit interval. The target commit interval only affects when the data is committed to the target table, not when the dynamic lookup cache is updated. Thus, the dynamic lookup will contain the 100th row immediately after it is processed, even though the target table commit interval is not reached.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
Explain the pipeline partition with real time example?
What are the main features of Oracle 8i with context to datawarehouse?
Write the unconnected lookup syntax?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to generate sequence numbers?
wf dont have integration severances how you can run?
What are the different types of olap? Give an example?
What are the types of schemas we have in data warehouse.
How can we improve session performance in aggregator transformation?
What is a stored procedure transformation?
Explain the types of lookup transformation?
explain one complex mapping with logic? sales project?
Enlist few areas or real-time situations where informatica is required.
Make a note of the quantity vaults made in informatica?
