The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker. The following tips will help the developer in addressing the performance of an ETL task, developed in Oracle Data Integrator (ODI) . Select appropriate K nowledge M odules (KMs) to load data. Each knowledge module available is designed for a specific technology. Identify this and use the one that fits best your implementation. If you are performing a simple file to Oracle DB transfer, using native Database utilities like SQLLDR or External Tables will provide an improved performance. Execution of joins and filters in the appropriate area provides significant improvement in the performance. If there are more records in the source ...