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 |