Archives of the TeradataForum

Message Posted: Fri, 16 Nov 2012 @ 19:41:38 GMT

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

Hi Forum,

Thanks for the responses. The Informatica consultant made the job work and the table is getting loaded at 500 records per second. However , when I try to run it from the Teradata server , I get the error - " Attempted to access out of range input data in felid....". I used the same script that Informatica generated to load the file. How is Informatica loading it fine and I run into the error when running from Teradata?

     **** 11:54:38 UTY6608 Import 1 begins.
     **** 11:54:38 UTY4203 Attempted to access out of range input data in field
          'COMMISSION_CODE', file

     'C:\Test\Test\Four_Seasons\Reservation_Daily_Element_Name_test.csv',record
          number '3'.

     ------------------------------------------------------------------------
     -
     -      Logoff/Disconnect
     -
     ------------------------------------------------------------------------
     **** 11:54:38 UTY6215 The restart log table has NOT been dropped.
     **** 11:54:38 UTY6212 A successful disconnect was made from the RDBMS.
     **** 11:54:38 UTY2410 Total processor time used = '0.187201 Seconds'
          .       Start : 11:54:33 - FRI NOV 16, 2012
          .       End   : 11:54:38 - FRI NOV 16, 2012
          .       Highest return code encountered = '12'.

Thanks

Roopalini

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