Set up direct links to replace the default Open Database Connectivity (ODBC) links to improve ETL performance.
When the source database is Oracle, you can use Database Link Mode and create a compatible DB Link from the Oracle Warehouse to the source. The Loading Knowledge Module (LKM) assumes that a database link already exists with the following naming convention: <DATASERVER_NAME>.WORLD@DSN_<DSN_ID>
. This database link must exist in the warehouse and be accessible using the warehouse credentials (user specified against the warehouse connection in ODI).
To use a database link for ETL:
ETL_SRC_VIA_DBLINK
parameter.