Suppose that in a big import
task, you expect only a limited number of import records to require
In this situation, you can use
a status field to allocate bulk processing to a high-performing
third party tool and specialized processing to USoft Batch.
Some tools are fastest at
loading bulk data into a database or performing simple computations
on it. On the other hand, USoft Batch is the best tool to perform
any specialized processing that is connected to business rules
already defined in the repository.
Example of a status field
allocating import tasks to tools:
||Define an additional status field (switch) in an appropriate
table. For example, TOOL_X if you want to allocate some of the
processing to a third-party tool X (such as Oracle's PL/SQL).
||Set the default value for the TOOL_X column to Y.
||Load all the data using a dedicated loader. TOOL_X ='Y' for
each imported record.
||Execute a USoft Batch SQL task setting TOOL_X = N for records
meeting a special condition. These records will be left out of bulk
||Have tool X process all the records WHERE TOOL_X = 'Y'.
||Have USoft Batch process all records WHERE TOOL_X = 'N'.