Fastload not picking decimal value

Database
Enthusiast

Fastload not picking decimal value

Hi ,

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.

Regards,

Sram

3 REPLIES
Senior Apprentice

Re: Fastload not picking decimal value

What's the datatype of the target column? Seems like it's truncated to an INT.

Enthusiast

Re: Fastload not picking decimal value

Hi,

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.

Br,

Khurram

Khurram
Enthusiast

Re: Fastload not picking decimal value

Hi,

iam loading from file to table, where table is having datatype varchar(100)