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
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is enterprise data warehousing?
how many types of dimensions are available in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
differences between service based and product based?
How can informatica be used for an organization?
What are the main features of Oracle 8i with context to datawarehouse?
What are the informatica performance improvement tips
If informatica has its scheduler why using third party scheduler?
In how many ways we can create ports?
What is joiner transformation in informatica?
Tell me about Propagate functions in informatica
In warehouses how many schemas are there?
What is deployment group?
wat are deployement groups in informatica, how it will be used for developers