Re: Parallel processing, merge Statement

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Tue, 02 Nov 2004 04:31:53 GMT
Message-ID: <Y4Ehd.353932$D%.163633@attbi_s51>

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.

Have a look at
http://www.oracle.com/technology/obe/obe9ir2/obe-dwh/etl2/etl2.htm

It's got some of the steps you want in it. Received on Mon Nov 01 2004 - 22:31:53 CST