Challenge Overview
Competition Task Overview
We have an existing data loader that loads data from tcs to dw, and now we want to make a few updates / enhancements to it:
- add 1st prize to project table.
- add new tables, project_technology and project_platform, we don't need to load the full look up tables, but just project_id, tech / plat id, and name.
- right now num_submissions and num_valid_submissions are not including checkpoints, please add two more columns for checkpoints (say num_checkpoint_submissions and num_valid_checkpoint_submissions).
Existing Code
You can find existing code from this link: https://coder.topcoder.com/internal/web_module/trunk/src/main/com/topcoder/utilities/dwload/TCLoadTCS.java
If you need to generate some test data, use this tool: https://coder.topcoder.com/internal/database/scripts/trunk/tools/TestDataTool/
If the tool doesn't generate enough data, you may need to manually insert some data.
SVN Access
If you don't have access to the SVN repositories, you should email support@topcoder.com to get access.
VM
VM will be assigned per request, please request for VM in the challenge forum.
Testing
You need to provide some test data and simple instructions to test your solution
Technology Overview
- Java
- Informix
- SQL
Final Submission Guidelines
Submission Deliverables
- Updated loader with the extra features implemented
- Detailed deployment guide on how to deploy and test your solution
- Test data
Final Submission
For each member, the final submission should be uploaded to the Online Review Tool.