As of Release 7707, DataMigrator has a new option that allows for faster loading when a source and target are in the same relational database. You can enable this option by opening the Flow Properties of a data flow and selecting the Optimize Load checkbox under the Execution section.
Since the operation is done as a single SQL command rather than row-at-a-time processing, some capabilities are not available when this option is selected. These include Record Logging and use of VALIDATE to reject individual rows. Also, a count of the number of rows inserted, updated, or deleted is not available.
The user should consider both modes of operation to determine which is best suited for their application.
WebFOCUS | |
Feedback |