Configuration Guide

Back Next

Add Staging Tables

Add a staging table to which you want to move data from a landing table.

In the

Hub Console

, start the Schema tool.

Acquire a write lock.

In the navigation tree, expand the node of the base object that you want to add a staging table to.

Right-click the Staging Tables node.

The

Add Staging Table

option appears.

The following image shows the

Add Staging Table

option to add a staging table to the Customer base object:

Click

Add Staging Table

The

Add Staging to Base Object

dialog box appears.

Specify the staging table properties.

The following image shows the

Add Staging to Base Object Customer

dialog box with the

Display Name

field set to S_CRM_CUST:

From the list of the columns in the base object, select the columns that the source system provides.

You can click

Select all columns

to select all the base object columns.

Specify column properties.

Click

The Schema tool creates the staging table in the

Operational Reference Store

along with any support tables, and then adds the staging table to the navigation tree.

The following image shows the S_CRM_CUST staging table in the navigation tree: