What happens if you increase commit intervals and also
decrease commitExplain grouped cross tab?
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
Explain your project of banking domian.
Scheduling properties,whats the default (sequential)
How we can create indexes after completing the load process?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What does role playing dimension mean?
How will the document be delivered to me?
Explain how to import oracle sequence into informatica?
Explain why we use partitioning the session in informatica?
Explain joiner transformation in informatica
Can we get 1st record through Informatica(without sequence number).
How is union transformation utilized?
What is the use of code page?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are some examples of informatica etl programs?
How to go to the older version for a mapping?