Re: sql loader

Rajiv Gangadharan wrote:
>
> > 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
> .
> .
> .
But this does not handle the UPDATE and DELETE scenario. Sybrand is more correct in his thinking (and this is the way most ETL is written) - never load directly into the destination table. Load into staging tables, and let PL/SQL do the movement into the destination tables.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.