Data Distribution offers the chance to distribute the desired data in stores. The distribution lets you control the distribution of data from head office to the stores. For example, the distribution of offers can be defined in such a way that certain offers are only available in a certain number of stores.
Table distribution
Table Distribution is used to specify the Data Distribution type used for individual tables in the system. It is only required if data should not be sent to all locations. With table distribution, the groups and the actions have a way to find out which data should be sent to each location.
The Table Distribution is closely linked to the Distribution list. The table distribution is a setup table where the type of distribution of different tables is defined, whereas in a distribution list the records are created for replication of records of tables on the basis of Table Distribution Setup.
When there is an insertion, modification, or deletion of a record in a table, data is entered in a Distribution list table which tells the system how to replicate this record. The distribution list is used to tell the system how individual records should be distributed.
Note the difference between Table Distribution, which dictates how tables are distributed, and Distribution List, which dictates where records are distributed. The Distribution List is only used to specify distribution based on records.
The Table Distribution Types are:
- All
- Specific
- By Master Only
- Table Default
- No Distribution
- All Default
For more information on each type see Table Distribution Types.