User Guide

11.0
- 10.0

Back Next

Specifying Output File Format Settings for the Loader

You can configure format settings for the output files to conform with the requirements of your target load utility. The load utility can then accurately load data to the target database.

Click the

Runtime Settings

tab >

Format Settings

view.

The following image shows this view:

Enter information in any of the fields, or accept the default values.

The following table describes the fields in the

Format Settings

view:

Field	Description	Default
Column separator	A character or character sequence that Fast Clone uses to separate columns in the output data files. Specify a character or character sequence that does not appear in the source data. Otherwise, the target load utility cannot correctly parse the data files. For more information, see Selecting Column and Row Separator and Enclosure Character Using Sampling. Fast Clone allows you to enter column separators that use the \x hh escape sequence in hexadecimal notation. Also, you can use the following non-printable ASCII characters: \a (alert) \b (backspace) \n (new line) \r (carriage return) \t (horizontal tab) \v (vertical tab) If you use non-printable characters as column separators, ensure that the target load utility supports these separators. For more information, see the target database documentation.	ASCII start of heading (SOH) for Hive targets Semicolon (;) for other targets
Record separator	A character or character sequence that Fast Clone uses to separate table rows in the output data files. Specify a character or character sequence that does not appear in the source data. Otherwise, the target load utility cannot correctly parse the data files. For more information, see Selecting Column and Row Separator and Enclosure Character Using Sampling. Fast Clone allows you to enter row separators that use the \x hh escape sequence in hexadecimal notation. Also, you can use the following non-printable ASCII characters: \a (alert) \b (backspace) \n (new line) \r (carriage return) \t (horizontal tab) \v (vertical tab) If you use non-printable characters in row separators, ensure that the target load utility supports these separators. For more information, see target database documentation.	\n
Enclosed by	A character or character sequence that Fast Clone uses to enclose character data in the output data files. Specify a character or character sequence that does not appear in the source data. Otherwise, the target load utility cannot correctly parse the data files.	Double-quotation mark (“)
Enclose numbers	Indicates whether to enclose numeric data with the delimiter value that you specified in the Enclosed by field.	Not selected
Enclose dates	Indicates whether to enclose DATE and TIMESTAMP data with the delimiter value that you specified in the Enclosed by field.	Not selected
Escape enclosure	An escape character that Fast Clone inserts before the value that is specified in the Enclosed by field whenever that value appears in data in text columns. If you enter an escape character, Fast Clone truncates the Enclosed by value to a single character.	Backslash (\)
Replace new line with space	Indicates whether to replace the line break character (\n) with the space character in unloaded data. Select this option if you use the line break character as the Record Separator value.	Not selected
Replace any char with	Click this button to define rules for replacing particular character sequences in the source data with another character sequence. For more information, see Defining Rules for Character Sequence Replacement.	-
Pad with blanks (fixed length)	Select this option to unload data to output data files that use fixed-length record format. If the number of bytes of field data is less than the field length, Fast Clone pads the field on the right with the space characters.	Not selected
Convert CLOBs from UTF16 into UTF8	Select this option to convert character data in source CLOB columns from UTF-16 encoding to UTF-8 encoding when loading the data to output data files. If you do not use UTF-16 encoding for source character data, clear this option to avoid the overhead of character set conversion.	Not selected
Convert numbers into packed decimal COMP3	Indicates whether to write numeric data to the output files as COMP-3 values. Select this option if you need to read the output file with COBOL or another language that has built-in COMP-3 support.	Not selected
COMP3 implied decimal	The COMP-3 implied decimal value.	0
Convert output ASCII into EBCDIC	Select this option if you need the output to be in EBCDIC format.	Not selected
Truncate numeric precision integer	The number of significant digits that Fast Clone uses to round down the fractional part of numeric values in the output. Valid values are from 1 to 36. You can override this value for individual source numeric columns. For more information, see Specifying a Custom Format for a Column.	No default
Unload binary into separate files	Indicates whether to write data from BLOB, CLOB, NCLOB, LONG, and LONG RAW source columns to separate files. In the data files, Fast Clone includes the file name instead of the source value.	Not selected for Netezza targets that use DataStreamer and Hive targets Selected for other targets
Trailing column separator	Indicates whether to append a column separator after the last column in each table row in the output data files. For Oracle targets, if you unload data from binary columns to separate files, Fast Clone does not append the trailing column separator after the last column if the datatype of that column is BLOB, CLOB, or XMLTYPE.	Selected
Suppress trailing null columns	Indicates whether to omit the last column value in the output data file if the column contains a null value. If you use DataStreamer to load Amazon Redshift, Greenplum, Netezza, Teradata, or Vertica targets, clear this option.	Selected
Timestamp format	The format to use for timestamp values from TIMESTAMP source columns. For more information about valid TIMESTAMP formats, see the Oracle documentation. You can override this format for individual TIMESTAMP columns. For more information, see Specifying a Custom Format for a Column.	YYYY-MM-DD HH24:MI:SS.FF6
Date format	The format to use for date values from DATE source columns. For more information about valid DATE formats, see the Oracle documentation. You can override this format for individual DATE columns. For more information, see Specifying a Custom Format for a Column.	YYYY-MM-DD HH24:MI:SS
Set local time zone	Select this option to unload values from columns that have the TIMESTAMP WITH LOCAL TIMEZONE datatype. Then enter your local time zone offset.	Not selected

Configuring Runtime Settings

Defining Rules for Replacing Characters in Data

Selecting Column and Row Separator and Enclosure Character to Use for Data Loading

Rename Saved Search

Table of Contents

User Guide

User Guide

Specifying Output File Format Settings for the Loader

Specifying Output File Format Settings for the Loader