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
- 17615 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
Explain Dataware house architecture .how data flow from intial to end?
What is meant by lookup transformation? Explain the types of lookup transformation?
Enlist the differences between database and data warehouse.
What are the popular informatica products?
How many ways are there to create ports?
difference between repository database and repository service?
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)
What can we do to improve the performance of informatica aggregator transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
How can we use batches?
What is union transformation in informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the advantage of informatica?
What is the sequence generator transformation in informatica?
Make a note of the quantity vaults made in informatica?
