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?
Answer Posted / akash
The cache data should not get impacted in this scenario. The commit interval is a target property.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the sequence generator transformation in informatica?
how tokens will generate?
what is INFORMATICA TESTING process
What are the databases that informatica can connect to windows?
What is the scenario which compels informatica server to reject files?
What do you mean by channel change?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Why do you use Mapping Parameter and mapping variable?
How identifying bottlenecks in various components of informatica and resolving them?
can u any challenge your project?
Explain the features of connected and unconnected lookup.
What are the conditions needed to improve the performance of informatica aggregator transformation?
Could you explain what is enterprise data warehouse?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Describe data concatenation?