Dataloader/MP Reference Manual

Introduction to DataLoader/MP
DataLoader/MP Reference Manual—424148-003
1-2
Loading Scenario
DataLoader/MP is a flexible product that lets you build loading applications quickly and
can help with the challenges listed. It consists of a file processing program,
DataLoader/MP, and a number of source files for load customization. DataLoader/MP
can work in conjunction with the NonStop SQL/MP LOAD and APPEND utilities.
Loading Scenario
A typical load scenario might involve a load operation from a single input source into
three partitions of a table. You need a DataLoader/MP process for the input stream and
a DataLoader/MP process for each LOAD or APPEND operation into a specific
partition. Figure 1-1 illustrates this scenario.
The initial DataLoader/MP process, A, reads a block of records from the input stream
and sends the record to the appropriate downstream DataLoader/MP process, (B),
based on key value.
DataLoader/MP process B reads blocks of records and performs any special
processing that might be required, such as conversions or reformatting operations. It
then writes the records to its $RECEIVE file. An SQLCI LOAD or APPEND process,
(C), reads the records, sorts them if necessary, and loads the records into the
designated target partition.
For additional features, see Section 6, DataLoader/MP Examples.
Figure 1-1. Loading a Single Input with DataLoader/MP
A
B
B
B
C
C
C
VDT014