According to fastload limitations i found out as Rule #6: No more than one data type conversion is allowed per column during a FastLoad. Why just one? Data type conversion is highly resource intensive job on the system, which requires a “search and replace” effort. And that takes more time. Enough said!
Now I wanted to take 1st 3 characters from a field. lets say i have data like xyzklm. i want to insert xyz while loading to teradata table. in fastload i am using substr(:var1,1,3). But it is throwing error "error 3618: Expression not allowed in Fast Load Insert, column columnname"
Re: can i do data converson for column in fastload
If the column is defined in the table as char(3), it should just take the first 3 characters without complaining. (You cannot take anything else like the 2nd, 3rd, 4th). Otherwise, use MLoad - this will take SQL expressions quite happily.