As well as creating new members, the other more common use of the staging process will be to update attributes for existing members (or indeed new members that you have created in the same batch). This is carried out by loading records into the staging table mdm.tblStgMemberAttribute.

As we saw in Chapter 4, there are two main types of attribute: domain and free-form. When loading domain attributes, we obviously need to ensure that the values we are trying to set already exist in the entity that the domain attribute is based on. In our example, we will update the following attributes for our newly-loaded UK stores:

In the following example, we first load records to mdm.tblStgMember, which will add new members for the Cities for any UK stores to the City entity to ensure the attribute update is successful. We then load records to mdm.tblStgMemberAttribute that will update the City domain attribute...