Optimize targets to enable the Data Integration Service to write to the targets efficiently. You can drop indexes and key constraints before running a mapping, increase the number of checkpoint intervals in the database, configure bulk loading in the write properties for a data object, and optimize an Oracle target database.