Teradata SQL Assistant Import Issue

Database
Teradata Employee

Teradata SQL Assistant Import Issue

Hi, 

I have  been trying to  import 1048576 records into  a table by in Teradata SQL Assistant using  import option in SQL Assistant.

But the importing process stops suddenly and  shows a random number of records imported and the process is marked "Import Completed"

but when i query the table it  shows  0 records.

1 REPLY
Junior Contributor

Re: Teradata SQL Assistant Import Issue

Is the target table a Volatile/Global Temporary Table defaulting to ON COMMIT DELETE ROWS?

 

SQL Assistant is not the best tool to import one million rows, did you change the batch size from 20 to 999?