i have txt file with decimal values. iam trying to load file to table(staging table with varchar datatype)
i have used format as vartext in fastload script,
in table its not populating decimal value.
for example i have 48.72 in txt file , in table its populating as 48.
please suggest me on this.
In fact when you load a Decimal value to VARCHAR, it is truncated after the decimal point.
Can you try with DECIMAL datatype in staging, e.g. DECIMAL(18,2). It will fix the issue.