Space between each character in Teradata mLoad target table

59 views Asked by At

I am loading a flat file into Teradata target table.

Example flat file:

Employee_ID, Employee_First_Name, Employee_Salary
1,Jay,50000
2,Sam,60000
3,Tom,70000

The result of the mload looks as such in the Teradata target table.

 1 , J a y , 5 0 0 0 0 
 2 , S a m , 6 0 0 0 0
 3 , T o m , 7 0 0 0 0

All target fields are specified as Varchar(1024).

Has anyone encountered something similar?

I was expecting the data to load as existed on the physical flat file.

0

There are 0 answers