I have a database schema which has many redundant tables for the same data, with the same columns (fields) in each one.
Each table represents measurements for a particular location at one time, e.g. hourly. The columns (fields of measurement) are the same and most are just numbers.
Currently each "Site" (location) has own table, with the same columns as the other sites.
I would like these combined into one table with a 'site' column that is a foreign key to the list of (about 30) sites. The SITE table exists already.
It would be good if this is a script (bash, PL/SQL etc) that can be run at any time on a Linux box.
To bid on this, I would like to know roughly which technique you are thinking of using and which language. I will show you the schema. Please include the word 'schmozza' in your bid so I know you have read this. I can also send you a database dump (about 700mb) or a VMware image which contains Oracle (about 12GB). I would like you to understand how to transfer and sync large files using UNIX and SSH.
11 freelancers are bidding on average $238 for this job
Having 8+ Years of Experience in Datawarehouse, SQL and PL/Sql Programming with Unix Shell Scripting. Delivered Critical Deliverable to the Clients like GE, Knape & Vogt,Deautsch Bank,BAe Systems,PGI etc.,
schmozza. Hi Please let me know in which language do you want reun the script either Perl or Shell and let me know your expections. Thanks &Regards Subhash Tetarwal