Show TOC

Field DefinitionLocate this document in the navigation structure

Use

On the Field Definition tab page you define the properties of the fields that you want to transfer.

Features

We recommend that you use a template when creating the open hub destination. The template should be the object from which you want to update the data. All the fields of the template are then available as fields for the open hub destination. You can edit the field list by removing or adding fields. You can also change the properties of these fields.

You have the following options for adding new fields:

  • You enter field names and field properties independently of a template.

  • You select an InfoObject from the Template InfoObject column. The properties of the InfoObject are transferred into the row.

  • You choose Select Template Fields. You are offered a list of the fields in the template for the open hub destination that are not contained in the current field list. You transfer a field to the field list by double-clicking on it. This allows you to transfer fields that had been deleted back into the field list.

If you want to define the properties of a field so that they are different from the properties of the template InfoObject, delete the template InfoObject entry for the relevant field and change the properties of the field. If there is a reference to a template InfoObject, the field properties are always transferred from this InfoObject.

The file or database table that is generated from the open hub destination is made up of the fields and their properties, and not the template InfoObjects of the fields.

If the template for the open hub destination is a DataSource, the field SOURSYSTEM is automatically added to the field list with reference to InfoObject 0SOURSYSTEM. This field is required if data from heterogeneous source systems is being written to the same database table. The data transfer process inserts the source system ID that is relevant for the connected DataSource. You can delete this field if it is not needed.

If you have selected Database Table as the destination and Semantic Key as the property, the field list is given an additional column in which you can define the key fields for the semantic key.

In the Format column, you can specify whether you want to transfer the data in the internal or external format. For example, if you choose External Format here, leading zeros will be removed from a field that has an ALPHA conversion routine when the data is written to the file or database table. Note that the user properties of the user who executes the DTP are used when you write the data in the external format. This has an effect on the decimal and date formats.