Re: sql loader

> Load the flat file in a temporary table.
> Then match your records with the production table by using sql and/or
pl/sql
> IMO, you shouldn't load flat files in a live table directly.

IMHO, you can load the data with the "append" option specified in the loader control file.
This option will take the place of the "truncate" option. The syntax will look like this.

load data
infile *
append
into table table_name
begindata

.
.
.