• 2nd Rock

    • Store
  • Get directions
    Business hours
2nd Rock
2nd Rock
Categories

Quote I221114

SKU 00041
$12,000.00
In stock
1
Product Details

Item

Time (hours)

Comment

Oracle import

15

  • Incremental load (eg off modified date column)
  • Full table load where there is no modified date
  • Identify tables to collect and configure load settings

Comment: a single view currently loading every 5 seconds with minimal load on the Softeon Oracle server, so confirms POC works.

Database Design/ Implementation

10

SQL Server:convert Customer > Region > Building to use surrogate keys

Tables for Ryan’s application and managers app.

Ryan’s Application

15

  • Update to use surrogate keys
  • Audit changes
  • Security settings for building: manager Region(s): Director + VP

Manager Application

10

  • Update with popup to use surrogate keys
  • Audit changes
  • Alerting for missing data > VP+ Director
  • Revise application to include warehouse space reservation

Daily data processing

15

  • Process of data collecting from different sources into a daily data format
  • Load data from managers data entry and pricing in Ryan’s application

Report Presentation

15

  • Data presentation for reporting

Total Hours

80

Save this product for later
  • Track Orders
  • Shopping Bag
  • Sign In
Display prices in: USD
Share Tweet Pin
© 2nd Rock Report abuse
Powered by