Neoview Database Administrator's Guide (R2.2)

Examples
• Suppose that your load task has this configuration:
4Input files
128Table partitions
1,000Transaction size
500Internal record
size
Use this formula to calculate memory allocation:
Memory allocation = ((2 * 4) + (3 * 128)) * 1000 * 500 = 196 MB
• Suppose that your load task has this configuration:
8Input files
256Table partitions
5,000Transaction size
500Internal record size
Use this formula to collate memory allocation:
Memory allocation = ((2 * 8) + (3 * 256)) * 5000 * 500 = 1.96 GB
Input Data Considerations For Load Tasks
Delimited Input Data
When you submit delimited input data, you must separate the data fields with a delimiter
character. You can use the default value, the '|' character, or you can specify a delimiter as part
of a task configuration with the fieldDelimiter (-fd) argument.
For example, if the fieldDelimiter argument is set as a comma (','), the input would be in
this format:
field 1, field 2, … ,field n
Data Formats
Following are guidelines for formatting delimited input data:
Character fields
Character fields can be submitted as text without being enclosed in double quotes, provided
that:
• The input data does not include a double quote character
• The input data does not include the field delimiter character
• The target column is a VARCHAR data type and trailing blanks are to be stored
• Leading blank characters are to be stored
For example, to enter the string VALLCO PARKWAY submit it as:
VALLCO PARKWAY,rest of input where the field delimiter is a comma.
Leading blanks are removed as the input data is read, unless the character data is enclosed in
double quotes.
Trailing blanks are removed as the input data is read. If the input field contains all blank characters
and the input is not enclosed within double quotes, all of the blank characters are trimmed and
100 Using the Neoview Loader