This switch should be successful in most cases, although it may not provide the most performant load possible. By default ODBC connections use the source table/column transformation loading method as dates and potentially other data types need to be converted.

When switching to a database link load any transformations will still occur although they may no longer be necessary.