InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 18:42:49 GMT20http://www.teradata.com/teradataforum/Topic11369-1-1.aspxhi Amit,you can try with INMOD routine in your DEFINE command to validate,modify or preprocess data before passing it on to Teradata RDBMS.thxTue, 06 May 2008 15:44:56 GMTSNhttp://www.teradata.com/teradataforum/Topic11369-1-1.aspxI 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,AmitTue, 06 May 2008 01:05:18 GMTamitaryans