Modify fastload script

UDA

Modify fastload script

I want to load data from a flat file into empty table. If the field in the file is NULL, the NULLIF will help me to give default value in the table.
However when the field in the file is having spaces or its zero lenght string, How can i handle this to assign Default values.
Are there anyways to perform some validations on such incoming fields in FASTLOAD SCRIPT.

Thanks,
Amit
1 REPLY
SN
N/A

Re: Modify fastload script

hi Amit,

you can try with INMOD routine in your DEFINE command to validate,modify or preprocess data before passing it on to Teradata RDBMS.

thx