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
- 17745 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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what is the -ve test case in your project.
Explain the tuning lookup transformation - informatica
What is the need for an etl tool?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How does a rank transform differ from aggregator transform functions max and min?
Explain lookup transformation is active in informatica
What are active and passive transformations?
Briefly explain the aggregator transformation?
What is powercenter on grid?
What is the difference between stop and abort in informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain in detail scd type 2 through mapping.
Explain lookup transformation source types in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
