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.
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.