Hi peeps,
As discussed many times that before importing a text file it is better to have temp table first where you will be importing the
texting file
then append the data from the temp table to the live tables. In creating temp tables, if you have the same text file format that
will be imported all the time, what's the best way to make use of temp table:
1.) delete-create temp table upon importing process, or
2.) have the temp table created during development and
let just the data be deleted every new import of textfiles
thanks,
enzo c",)