Archives of the TeradataForum

Message Posted: Wed, 09 Feb 2011 @ 09:26:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thanks for the reply.

I am able to load the values from the flat file to the table via Tpump.

The issue is the below flat file header also is inserting in the table. How to avoid this.

Source.txt

     ACCOUNT_NUMBER,STREET,STATE,ZIP_CODE
     20030840,Pier Avenue ,CA,94123
     20025559,Budlong Ave ,CA,90066

Tables Values

     20027590   Madrona Ave          CA   90020
     ACCOUNT_   STREET               ST   ZIP_C

I have defined the layout as below

     .FIELD ACCOUNT_NUMBER    * VARCHAR(100);
     .FIELD STREET       * VARCHAR(100);
     .FIELD STATE       * VARCHAR(100);
     .FIELD ZIP_CODE    * VARCHAR(100);

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>