Adding InfoObjects

You define the DataStore object by adding InfoObjects and/or fields.

1. Choose the Details tab.
2. To add an InfoObject, choose Add InfoObject. Specify the start of the name, select an InfoObject from the result list, and press OK. You can also select multiple InfoObjects by pressing Ctrl + Shift. The InfoObjects are added to your DataStore object. Any compound characteristic are added too.
3. You can now configure further settings for the InfoObject properties in the right screen area.
4. Under Maintain Properties, you can make aggregation and master data check settings for all InfoObjects/fields that support this:

   You can select an aggregation type under Aggregation.

   Under Master Data Check, you can decide whether you want to check for referential integrity or whether you want to run the check when data is loaded or queries are executed and whether you want to save the SIDs. Saving SIDs is useful if you have a compound characteristic with high cardinality and mainly navigation attributes of this compound characteristic are used in the query. This means the join must be executed very frequently, which can have a negative impact on performance. An additional column is created in the table for the purpose of saving the SIDs for this InfoObject. This column is filled during activation.

5. If you choose Use Navigation Attributes in Extraction, the navigation attributes of this InfoObject can be used in the transformation, if the DataStore object is the source of the transformation. In addition, you can use the navigation attributes as filter criteria in the DTP.
6. You can use groups to organize your InfoObjects. There are no semantic restrictions here. To do this, choose Add Group. You can change the technical name of the group and enter a description. You can move InfoObjects from one group to another using drag and drop.
7. You can define keys. More information: Defining Keys
8. To delete InfoObjects, choose Delete.