Focal Point
How to perform "DIRECT LOAD" from Data Migrator to Oracle?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/6831065682

June 04, 2008, 05:33 PM
Morgan
How to perform "DIRECT LOAD" from Data Migrator to Oracle?
I am being requested by my DBA to use Direct Load "To reduce archive logs generation – we will need to use direct load option."

I have changed the properties of the target to "Bulk Load utility via a Disk File" With the Direct Path Load option set to yes

Is this how I set DM for a direct load to SQL loader or is there something else I need to do?
June 12, 2008, 11:25 AM
Kerry
Hi Morgan,

Has this issue been resolved? The following online document may be of interest:

Specifying Data Target Options
See -Oracle Target Bulk Load Options

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
June 13, 2008, 07:09 AM
alruby
Kerry,

What release of Data Midrator is this avaliable in?

Thanks,
Allen.
June 13, 2008, 10:05 AM
Clif
Support for ORACLE SQL*Loader Direct Path has always been available in DataMigrator, and in predecessor products back to Release 3.3.