Search found 1 match

by gvalerio
Fri Oct 26, 2012 4:07 pm
Forum: Informatica PowerCenter
Topic: Slow inserts through Informatica
Replies: 4
Views: 3825

Re: Slow inserts through Informatica

The default commit level of 10,000 within Informatica is typically too low if you are loading 100s of millions, billions, or even trillions of rows. In my experience using Informatica and Vertica to load over 35B rows, a commit level of 10M decreased a 6-hour load job to less than 60-minutes.

Go to advanced search