Creating the Source Data File - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

Create and save a six-record text file named insert.input:

|10021   |Brown, Jo   |200|2312|Development |63000.00 |20|Jan 01 1955|F| |M|16| 0|
|10001   |Jones, Bill |100|5376|President   |83000.00 |15|Jan 01 1960|M| |M|14| 0|
|10002   |Smith, Jim  |100|4912|Sales       |73000.00 |10|Jan 01 1970|M| |M|13| 1|
|10028   |Lee, Sandra |200|5844|Support     |77000.00 | 4|Jan 01 1971|F| |M|18| 0|
|10029   |Berg, Andy  |200|2312|Test        |67000.00 |10|Jan 01 1967|M| |M|15| 0|
|10023   |Ayer, John  |300|4432|Accounting  |52000.00 | 8|Jan 01 1965|M| |M|13| 0|

Use this file as the input source for a Teradata MultiLoad import task.

The file example uses field delimiter characters (|) for readability, to help distinguish one field from another. Field delimiter characters are not required in files.