For ODI daily ETL,there are some settings that may affect performance. The setting values are specific to the data source.
In the ETL_PARAMETER table:
select p_1 from ETL_PARAMETER where p_feature in ('odi.spread.percent.threshold', 'odi.spread.update.percent')and datasource_id=9;
The default value is 25. For Medium and Large databases, reduce this number. For example, set to value 10 for medium database and 3 for large database. If an entry is not there, insert one for each datasource as follows:
insert into ETL_PARAMETER (p_feature, p_1, datasource_id) values ('odi.spread.percent.threshold', 3, 9);
insert into ETL_PARAMETER (p_feature, p_1, datasource_id) values ('odi.spread.update.percent', 3, 9);