Loading data from multiple files

[Guest]

Hi.

I have to load data from our order processig system into the
Datawarehouse.

File name format is dataDDMMYYYY.txt for example
data01012005.txt etc.

Is there any way to specify a mask wnen i want to reload data for
specific month or year?

Peter

[Mark C. Stock]

<Peter_Jonson22@yahoo.co.uk> wrote in message
news:1110110331.468485.74240@z14g2000cwz.googlegroups.com... Hi. I have to load data from our order processig system into the Datawarehouse. File name format is dataDDMMYYYY.txt for example data01012005.txt etc. Is there any way to specify a mask wnen i want to reload data for specific month or year? Peter

SQL Loader?

If OS command line wildcards won't do it for you, try shell scripting or
windows host scripting to generate the load scripts and commands.

++ mcs

[Rauf Sarwar]

Peter_Jonson22@yahoo.co.uk wrote: Hi. I have to load data from our order processig system into the Datawarehouse. File name format is dataDDMMYYYY.txt for example data01012005.txt etc. Is there any way to specify a mask wnen i want to reload data for specific month or year? Peter

To see e.g. all files for month 012005 do,

C:\> dir /b data*012005.txt
$ ls -b data*012005.txt

You can script it any way you want.

Regards
/Rauf

[Guest]

Thanks for the suggestions.

Sorry I did not make it clear I am actually looking for a GUI tool
which can help me.
Something which will alow my customer to define mapping between file
and target table, specify file(s) to process and load data into the
database.
Scripting is way too complicated for the customers I am dealing with.

Peter,
U.M.G.I

[Shamil ZALYALOV]

I guess you even know it - it's Oracle Warehouse Builder.

More info at: http://www.oracle.com/technology/products/warehouse/index.html

Cheers,
Shamil

<Peter_Jonson22@yahoo.co.uk> wrote in message
news:1110191801.003272.237100@f14g2000cwb.googlegroups.com... Thanks for the suggestions. Sorry I did not make it clear I am actually looking for a GUI tool which can help me. Something which will alow my customer to define mapping between file and target table, specify file(s) to process and load data into the database. Scripting is way too complicated for the customers I am dealing with. Peter, U.M.G.I

[Rauf Sarwar]

Peter_Jonson22@yahoo.co.uk wrote: Thanks for the suggestions. Sorry I did not make it clear I am actually looking for a GUI tool which can help me. Something which will alow my customer to define mapping between file and target table, specify file(s) to process and load data into the database. Scripting is way too complicated for the customers I am dealing with. Peter, U.M.G.I

What is your Oracle version and OS that you are working with?
How do you want to load data into the database,

1) Push it into the database using e.g. SQL*Loader?
2) Pull it into the database from flat files using e.g. utl_file
package?

Google does not charge by the number of characters you post... feel
free to provide as much detail as you can.

Regards
/Rauf

[Guest]

It is windows 2000 and Oracle 9i if it will help

Peter

[Mike]

Looks like we've got a tool you are looking for

VImp loads data from multiple tables or files into Oracle MS Sql Server
or any ODBC compliant Database

http://www.dbsoftlab.com/download.php?view.5

Mike

[Malcolm Dew-Jones]

Peter_Jonson22@yahoo.co.uk wrote:
: Thanks for the suggestions.

: Sorry I did not make it clear I am actually looking for a GUI tool
: which can help me.
: Something which will alow my customer to define mapping between file
: and target table, specify file(s) to process and load data into the
: database.
: Scripting is way too complicated for the customers I am dealing with.

So write a script that shows a menu of options.

The user selects the menu option they want (including for example a file
to load). Your script converts that into a sql loader file that loads the
file. Then it displays the resulting log files in some organized manner.

You can make it as pretty and gui as you wish.

Hardest part is probably to display an easy, controlled, file select. On
Windows use Perl Tk::FileSelect, or visual basic (GetOpenFileName()?), or
there are myriad other options - perhaps really impress them by sending an
outlook mail message with a built in form that drives the load process and
sends any series error conditions back to the help desk...

Even a couple of DOS-ish batch files would probably work in a pinch -
hardest part would be selecting the files in that case.

$0.02

--

This space not for rent.

[Peter]

Mike
Thaks for the tip
Will it load data from Pivot tables?