Hi Oracle Data Integrator (ODI) community,
We do have requirement to load data from Teradata to Oracle DB.
Source: Teradata view
Volume: 40 million rows
Target: Oracle table
Currently I am using the below under Physical tab:
LKM: SQL to Oracle
IKM: IKM SQL Control append
Truncate option: True
Flow control : False
Every time I need to truncate the table and do the bulk load.
By using above LKM Sql to Oracle, C$ table is being created and taking long time to extract data from source.
Using Data Integrator Version 12.2.1
I would appreciate if someone suggest what's the best way to load this huge volumes.
Thanks.