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.
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?