摘要:[SSIS]SSIS Microsoft connection MSORA, Oracle Destination Data Access Mode
SSIS ETL (Oracle to Oracle) transfer 1 million data performance improved from 1h30 to 1m30 by using Microsoft connection MSORA by attunity - Oracle Destination Fast Load mode
Oracle Destination component:
Data access mode has two different modes, which is using primary key or not when insert the data.
1.Normal Mode “Table Name”
If your data table have primary key like that you have to use normal mode “Table Name” mode when insert oracle data
However, when your data table have primary key, can I use “Table Name Fast Load”? the answer is “Yes”, the Oracle Component will change the data table primary key status form “Valid” to “Unusable” for insert duplicate primary key data. And the data table will occur error when you want to delete data or rebuild primary key
You can take care about the duplicate data by using error output path, you can use OLE DB Destination to insert data table again or insert the Flat File for record error raw.
2.Fast Mode : “Table Name Fast Load”
Otherwise, If your data table don’t have primary key like that you can use fast mode “Table Name Fast Load” mode when insert oracle data.
p.s using Fast Load mode, the component will replace column value from“ ”(Single space) to Null. Otherwise Normal Mode doesn’t.