Combine 3 retail stores Sales data to one central location. And then delete the old data from original tables
The source Database is based on Advantage Database server Tables [url removed, login to view]
The target tables would keep the same structure and the same database.
Some primary keys would have to be changed in order it should stay unique
Looking to implement this solution using Pentaho Data Integration with meta data.
Getting this bid would also have to guide me how to setup Pentanho / kettle
the source and target tables are in 4 Locations on a VPN Windows OS
(this is not the same job as my other job)
Files and detals of project on
[url removed, login to view]
Pass Central123 (C is in Caps)