Hi- I am using a fastload script to load a .csv into Teradata. The only problem I am having is with importing the data in the "Charge" column as a decimal. Typically data in this column is as such:
I am trying to maintain data 3 places to the right of the decimal point, but for some reason the data is being rounded as such:
Below is the script I am using to load data from the csv into a teradata table :
The issue is
, Charge Decimal(3)
You don't specify the decimal fraction so it will be 0.
, Charge Decimal(6,3)