Re: Parallel processing, merge Statement

Rick Wiker wrote:

> I have a procedure that pulls up to 1 million records per day from an
> external database through a database link. Currently I insert the
> records into a staging table and then run a merge statements to update
> my local tables.
>
> I have been looking at some of the ETL enhancements added to 9i. It
> appears that it would be more efficient for me to use an external
> table and pipe the data to the merge process, but I'm really not sure
> how to go about doing so.
>
> Does anyone have an example of how this would be accomplished?
>
> Thanks for any assistance.

1. Create external table pointing to file that will be created in step 2
2. UTL File to produce file on source server
3. FTP recipient server
4. SELECT from external table and do what you will.

Daniel A. Morgan
damorgan_at_x.washington.edu Received on Mon Nov 01 2004 - 20:58:21 CST