Hp Neoview Release 2.4 Software Instrukcja Użytkownika Pobierz pdf (Strona 55)

• Each target table has its own staging table.

• The names of staging tables are generated by Transporter and written to the Transporter

log.

• Source rows are first written to staging tables. When all source rows for a given target table

have been written to the staging table, Transporter populates the target table.

• Jobs using staging tables cannot be recovered if the failure occurs during the staging table

to target table row transfer.

multipart

multipart = "true" | "false"

The default is “false”.

For an extract operation when this option is set to “false”:

• Transporter uses the value of “parallelstreams” (page 57) to determine how many internal

data streams to manage and records from all internal streams are merged into a single target

file or pipe.

• Rows in the target file or pipe do not appear in any particular order. If the extract source is

a Neoview SQL query containing an ORDER BY clause, the specified ordering is not

maintained.

• If the extract target is of type file and parallelstreams is greater than one, Transporter

first writes records to a collection of intermediate files and then merges these files into the

single target file.

• The number of intermediate files is determined by the parallelstreams option. The

names of the intermediates files are:

name-of-target-file.NNNN

Where NNNN is a zero-padded four digit integer.

For example, if the specified target file is “extractData” and the value of

parallelstreams is 4, the following intermediate files are used:

extractData.0001

extractData.0002

extractData.0003

extractData.0004

For an extract operation when this option is set to “true”:

• Target file or pipe names in the control file are interpreted as a prefix only.

• If the extract source is a Neoview SQL query containing an ORDER BY clause, each target

file or pipe is ordered accordingly. However, there is no guaranteed ordering relationship

among the different targets. For example, if the ORDER BY list is a single integer column,

values for the ordering column might be [1,3,5] in one target and [2,4,6] in another.

• Transporter generates a unique suffix for each actual target file or pipe. The number of actual

targets is determined by the parallelstreams option.

The suffix is:

.NNNN

Where NNNN is a zero-padded four digit integer.

For example, if the specified prefix is “extractData” and the value of parallelstreams

is 4, the following targets are used:

extractData.0001

extractData.0002

extractData.0003

extractData.0004

This option is ignored for load operations.

multipart 55

1 2 ... 50 51 52 53 54 55 56 57 58 59 60 ... 123 124

Komentarze do niniejszej Instrukcji

Brak uwag

Hp Neoview Release 2.4 Software Instrukcja Użytkownika Strona 55

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie Hp Neoview Release 2.4 Software