On Fri, 8 Jun 2001, Pettit, Chris L wrote:
..
> I've used Perl to prepare large files for SQL Loader.
> 1.9 million. SQL loader is fast, I was able to load the 1.9 mill records in
> less than six minutes.
> We had to do text extraction for the data.
> DBI is absolutley awesome for that IMHO.
I believe this is a DBI success story (read it on TPJ). A large bank in
Spain (was it) used something like this, using Perl to pre-format a huge
quantity of legacy data for importing into their data warehouse. For
pre-formatting data I believe Perl is a winner. Oracle SQL*Loader can take
care of it after that.
--
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GE d(-) s: a-25 C++++ UBLSI++++$ P+++ L+++>++++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
------END GEEK CODE BLOCK------
