Re: Loading Data with Logic

You are aware you can perform calculations in SQL*Loader? Personally I would never load directly into 'real' tables, always in technical tables.
In 99 percent of all cases the data you get from external parties doesn't confirm to YOUR rules and you have to clean it out anyway. For me this means a technical table with NO constraints (except NOT NULL), which will load allways and a production table with everything into place. PL/SQL procedures can perform the logic fine, unless you have really vast quantities to load. In that case you should use anything supporting array fetches and array inserts. Pro*C will do this and more recent versions of PL/SQL (I believe 8i and higher)

Hth,

--
Sybrand Bakker, Oracle DBA
<stuco_at_cobaltspoon.com> wrote in message news:86n1sh$bro$1_at_nnrp1.deja.com...
> ORACLE 8.1.5
> Windows NT
>
> I am loading data from a flat text file into multiple tables. A lot of
> the data in these tables, however, needs to be generated based on the
> content of the flat file. Needless to say there is lots of logic that
> needs to be performed at load time.
>
> My approach is to load the data into a temporary table and use PL/SQL
> to load the real tables with the necessary logic. Is this the best way
> of doing this??
>
> I had toyed with the idea of using row-level triggers, but found that
> it could get really messy. How about these precompilers like Pro*C? Are
> they worth anything?
>
>
> Thanks for all your help
>
>
> Stuart Cowen
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 26 2000 - 09:45:41 CST