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?
- 2 Answers
- 14397 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
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 are the new features of informatica 9.x in developer level?
What is the need of an ETL tool?
Explain direct and indirect flat file loading (source file type) - informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is a rank transform?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is rank transformation in informatica
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to generate sequence numbers using expression transformation?
Why do you use Mapping Parameter and mapping variable?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Whats there in global repository
What is powercenter on grid?
Explain the etl program with few examples.
Which transformation should we use to normalise the COBOL and relational sources?
