Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 01 Nov 2003 @ 12:16:22 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Moving Oracle Dump File to Teradata
 
From:   Chris Coffing

MLOAD Supported Input Formats

Data input files come in a variety of formats but MultiLoad is flexible enough to handle many of them. Multiload supports the following five format options: Binary, FastLoad, Text, Unformat and Vartext. Here is a chart depicting each format:

BINARY
Each record is a 2-byte integer, n, that is followed by n bytes of data. A byte is the smallest means of storage for Teradata.

FASTLOAD
This format is the same as Binary, plus a marker (X '0A' or X '0D') that specifies the end of the record.

TEXT
Each record has a random number of bytes and is followed by an end of the record marker.

UNFORMAT
The format for these input records is defined in the LAYOUT statement of the MultiLoad script using the components FIELD, FILLER and TABLE.

VARTEXT
This is variable length text RECORD format separated by delimiters such as a comma. For this format you may only use VARCHAR, LONG VARCHAR (IBM) or VARBYTE data formats in your MultiLoad LAYOUT. Note that two delimiter characters in a row will result in a null value between them.

Take a look at the .SET command to set the delimiter to a comma.


Hope this gets you what you were looking for..

Chris Coffing
Senior Vice President
Coffing Data Warehousing
www.coffingdw.com



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023