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
- 17795 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 meaning of decode in informatica?
difference between repository database and repository service?
What is a stored procedure transformation?
Can we create multiple integration service on single repository?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What do mean by local and global repository?
Different qualification between a related rotate toward the sky and isolates look upward?
How can we store previous session logs?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is resilience time?
Define pmcmd command?
Enlist some properties of sessions.
4 yrs etl devloper roles and responsibilities?any body give solutions
How to load data in informatica ?
How big was your fact table
