Interested to Buy Any Domain ? << Click Here >> for more details...
What happens if you increase commit intervals and also
decrease commitExplain grouped cross tab?
- 2 Answers
- 19159 Views
- I also Faced
- E-Mail Answers
Answer Posted / sasikumar_bes
if you have increased your commit interval to ~25000 rows
the session will run faster but when your session fails at
24000th record you will not have any data in your target.
When you decrease your commit interval to ~10000 rows your
session will be slow when compared to previous but if the
session fails at 24000th record you will lose only 4000
records.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
How we can create indexes after completing the load process?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we override a native sql query within informatica?
What is source qualifier transformation in informatica?
What are the new features of informatica 9.x at the developer level?
How to create the source and target database connections in server manager?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Tell me about MD5 functions in informatica
Explain how many types of dimensions are available in informatica?
How can we use batches?
How do you load only null records into target? Explain through mapping flow.
What are the new features of Power Center 5.0?
Tell me about Propagate functions in informatica
What differs when we choose the sorted input for aggregator transformation?
Explain transaction control transformation in informatica
