Is it possible to bulk load textfile into Table instead for External Table in Netezza?
I am bulk loading data in to Netezza from the text file using EXTERNAL TABLE and after loading data in to external table I am updating those some columns in the same external table since you cannot update external table I have to stage all the data from external table to one Temp Table and than I able able to do the updates whereas Is there any other way where I can directly bulk load the textfile data into the Table instead of External Table in Netezza?
Answer
If you are using straight ODBC. I would consider a "Transient External Table"
INSERT INTO target_table SELECT * FROM EXTERNAL 'C:\FileName.txt'
using( delim '|' datestyle 'MDY' datedelim '/' REMOTESOURCE 'ODBC' MAXERRORS 50
LOGDIR 'C:\');