Don't include the delimiter characters or newline in the DEFINE.
UNFORMATTED is used for "fixed format" records with positional fields and binary data.
FORMATTED (also known as FastLoad format) is used mainly when the input was created by a Teradata export utility.
Just use below define statement as the data file doesn't have any starting and trailing delimiters and you just need to press enter while creating the sample data i.e your cursor should be in next line.
your sample data:
Try with the above define and sample data, It should work fine.BTW, Add checkpoint and other commands in begin loading command (as in our earlier reply)
SET RECORD VARTEXT "|";
Your DEFINE command looks like you want to use UNFORMATTED :-(.
If you DEFINE command as kusumayella provided, it should work!
Please read the FastLoad manual for record format usage. CHECKPOINT 1000 and INDICATORS are part of the BEGIN LOADING command. Please refer to the manual for the BEGIN LOADING syntax. The manual also contains examples that can be useful for you.
I see you starts several threads for the same issue!
If you don't have the FastLoad manual handy to write FastLoad script, let me know, I will provide you the link.