I'm using Vertica plugin for Informatica 9.1 to insert data. The speed is generally good. But every once in a while its slows down to a trickle and I see the informatica session logs fill up with this message:

[INFO] accepted 104 rejected 0 144537824

Anybody know what would cause this? Could this be the WOS getting filled up and spilling over into ROS?

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.