A new Teradata MLOAD parallel job loads one column of a table from a dataset -- the column is of type/size CHAR(11). The TD MLOAD job reads the file, but wants to truncate the data by one character. Everything across the board is CHAR(11). No truncation is needed. The data gets loaded, but is wrong -- it is missing the final 11th character.
WE get the same results with a sequential file as input.
Here is the warning I'm getting:
TW_PAVE_SKUS,0: Warning: At row 1, link "SEQL_PAVE_PP_INTO_E1DW_WORK_PAVE_SKUS", while processing column "SKU"
Value "1000BBA4106" truncated to "1000BBA410"
Argh!!! Any ideas?
TD MLOAD truncating 11th character of CHAR(11) input -- why?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
unicode seems to have been the culprit
I had turned unicode on in the column metadata info as I was getting an error about type conversion from string to ustring. When I ran it without the unicode setting on the target columns, it loaded correctly without truncation. Guess there's always more to learn about unicode...
FYI: format was FASTLOAD.
Any thoughts on whether FASTLOAD or VARTEXT would make a difference?