1 / 7

Module 6 ********* Data Loading

Module 6 ********* Data Loading. Workforce Information Database Training Last update November 2006. Module 6 Data Loading. What are the common data loading problems relevant to the Workforce Information Database ?. Module 6 Data Loading. Data Loading Guide.

monty
Download Presentation

Module 6 ********* Data Loading

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Module 6 ********* Data Loading Workforce Information Database Training Last update November 2006

  2. Module 6 Data Loading What are the common data loading problems relevant to the Workforce Information Database?

  3. Module 6 Data Loading Data Loading Guide 1. Assure the received data load has all the fields or can be aggregated to create the necessary fields to fit the table in the Workforce Information Database structure. 2. Assure the fields are in the correct format as the Workforce Information Database (DB) structure. 3. Assure the geographies of the data load are consistent with the Workforce Information DB geog table.

  4. Module 6 Data Loading Data Loading Guide • 4. Assure data load contains all geographies that will be represented in the retrieval software. • Load the data load via a data loader to ensure data integrity. • 6. If errors occur from the load attempt, correct those erroneous records and reload them via data loader.

  5. Module 6 Data Loading Data Loading Guide continued... 7. Document data load on the data tracking log. 8. Test retrieval software/system to assure the recently loaded data load is accessible and reasonable or review data in the table for validity and integrity. ************************* ALWAYS load to a test server/database before production!

  6. Module 6 Data Loading Workforce Info DB Load Order (Refer to Handout)

  7. Module 6 Data Loading WORKFORCE INFORMATION DATABASE LOGICAL DATA MODEL FOR LONG-TERM EMPLOYMENT PROJECTIONS

More Related