Data loading via fastload

Tools
Enthusiast

Data loading via fastload

Hi,
I am facing a severe problem while loading data via fastlaod
My column data type is decimal(30,5)
But my source data is having precision 20 ...(30,20)
Please help me out what i should do??
2 REPLIES
Enthusiast

Re: Data loading via fastload

Hi,
Any bodies help will be appreciated...
I need to load a decimal data with different precision...

data type of table-----decimal (30,5)

source ----decimal(10,20)

Please help me out...
Enthusiast

Re: Data loading via fastload

In the Define statement, set the field to as it is on the input record. eg:

Define BigNum (Char(32) ...... (Assuming it is character input) or
Define BigNum (Decimal 30,20) it is comes in raw form)

DBC will convert the data by truncating the excess fractional digits when the data is stored in a (30,5) field on the database.

Will only work in Teradata 12 - up to this point the maximum size of a decimal field was 18.