Staging table settings
For a business object to have a staging table that is associated with it, the Has Staging Table property of the business object must be on. In addition, fields within the business object must be identified as staging table fields with their Staging Table Field property on. Publishing a business object establishes or updates the associated staging table. A business object can have only one staging table.
Business objects with staging tables
In the IBM® TRIRIGA® Administrator Console, select the DataConnect managed object then Business Objects with Staging Tables to see a list of the business objects with staging tables.
To see the staging table fields for a particular entry, select the line item and click Expand Data. The Fields column then shows the IBM TRIRIGA name for the field, a hyphen, and the database name for the field. If the field is a key field that is used for Upsert, the field name has an asterisk. DataConnect smart section keys display the section name followed by the field name. Field definitions are useful for identifying the corresponding staging table fields for inbound data. For more information, see the IBM TRIRIGA Application Platform: Administrator Console User Guide.
Has staging table
The Has Staging Table property identifies those business objects for which IBM TRIRIGA maintains staging tables. If the property is on and the business object is published, a staging table is either created or updated. If the property is off and the business object is published, the publish process deletes the staging table if it exists. By default the Has Staging Table property is off.
When the business object is brought in through object migration and object migration publishes the business object, a staging table is created for a business object that has the Has Staging Table selected.
Staging table field
The Staging Table Field property identifies those fields to be included in the business object staging table. If the property is on, the field is included in the staging table. Changes to this property after a staging table is created are not reflected in the staging table until the business object is republished. By default the Staging Table Field property is off unless the field is required.
The Staging Table Field property is supported for the following field types: Boolean, Business Object, Classification, Color, Date, Date and Time, Duration, List, Locator, Number, Password, Text, Time, UOM, and Url. Only fields that are in the General section are supported to be staging table fields. Fields in a smart section can be added to the staging table. All required fields have the Staging Table Field property on.
If you set the Staging Table Field property for a number field that has a related UOM field in the business object, be sure to set the Staging Table Field property for the related UOM field. You must also set the Staging Table Field property for the related UOM, if the UOM that is being imported is different from the base UOM. For example, if the base UOM for area is square feet and the UOM being imported is acres, set the Staging Table Field for the UOM that is imported.
You can also include formatted values for Date, Date and Time, Duration, and Time fields in staging tables. If the property for these DataConnect format fields is turned on, the field is included in the staging table. The name of the field is appended with _F in the staging table. For example, if the Staging Table Field property for the date field that is named TRIDATEDA is turned on, the field TRIDATEDA_F is included in the staging table. The format of these fields is determined by the user preferences of the user. Usage of these format fields is optional. If you want to include these format fields in the staging table, you must publish the business object to apply the change.
Staging table key
The Staging Table Key property identifies fields to be used as keys to find a record through the Upsert or Update action. The Insert action does not use this property. By default the Staging Table Key property is off. It can be selected only when the Staging Table Field property is selected.
The Staging Table Key property is supported for the following field types: Boolean, Business Object, Classification, Color, Date, Date and Time, Duration, List, Locator, Number, Password, Text, Time, UOM, and Url.