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
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Where can we find the throughput option in informatica?
What are the advantages of using informatica as an etl tool over teradata?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
As union transformation gives UNION ALL output, how you will get the UNION output?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain sessions and how many types of sessions are there?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
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)
Briefly define reusable transformation?
What is rank transformation in informatica
what is SDLC way of code development?
What is the sequence generator transformation in informatica?
Can we create two repositories on same database instance in oracle?
What are the guidelines to be followed while using union transformation?