Loading Data to the Tables

The migration environment uses an Info Page under the Load Data to FINAL and HIST Tables data model to send the data extracted with DataSync to different tables.

Each table created by the template zip package has 3 versions:

  • STG table

  • HIST table

  • FINAL table

DataSync first sends the data from your source tables to the STG Table. After running the Info Page, SEI sends the data from the STG table to the FINAL table the first time it is run. In subsequent loads, you can choose to update the HIST or the FINAL table.

To load data into the tables:

  1. Right-click the Load Data to FINAL and HIST Tables data model and select View Info Pages.

  2. In the Load to Respective Table section, click the prompt icon and select the Module or Table Name from the list.

    To select multiple modules, use the Shift or Ctrl key.

  3. Click Load or Load All.

What's Next

Proceed to validate the data.