Target Load Type is important: Bulk cannot work if target object has indexes (#Oracle database fails with ORA-26002: Table has index defined upon it error) but is faster due to limited ability to recover because no logging occurs. Normal mode works with indexed target objects. #PowerCenter #ETL #protip #tip