To get good and consistant throughput on huge loads (Informatica)

If the performance while loading a huge table is decreasing with time, here is onething to try:

The performance of the load can be consistant if we sort the data (in sql override) based on the column which is PK and indexed on the target. This prevents the data from being sorted while loading into the table.

Ex:
select col1,col2,.....col200 from xyz order by col2

Note: (provided col2 is indexed and PK of the target table)