My file is a delimited file, can i specify INT or CHAR in multiload layout

General

My file is a delimited file, can i specify INT or CHAR in multiload layout

Hi,

Could anyone please tell me, can i specify INT or Char  in  multiload layout. If my source file is a delimited file?

eg: .Layout puru;

.field prod_id 1 INT;

.field product_name * vartext(10);

.field product_quantity * vartext(10);

.field order_id * INT

But my source file is a delimited file.

Thanks in advance.

Regards,

2 REPLIES
Teradata Employee

Re: My file is a delimited file, can i specify INT or CHAR in multiload layout

The .LAYOUT describes the input record. If you .IMPORT VARTEXT (delimited) then all .FIELD should be VARCHAR.

The corresponding columns in the target table could be INTEGER.

Re: My file is a delimited file, can i specify INT or CHAR in multiload layout

Hi fred,

Thank u so much...

Regards,
Purushotham.