A key aspect of managing loads and queries in larger databases is Sybase IQ’s transaction-level versioning.
In particular, Sybase IQ offers the ability to roll back transactions to intermediate save points, so that you may not need to repeat the entire load if a long transaction is unable to complete.