Define dynamic learning attributes
To define dynamic learning attributes, you must populate the UACI_AttributeList table in the Learning data source.
All columns in this table have the type of varchar(64).
Column | Description |
---|---|
AttributeName | The name of the dynamic attribute upon which you want to learn. This value must be an actual value possible in the AttributeNameCol. |
AttributeNameCol | The fully qualified column name (hierarchical structure, starting from profile table) where the AttributeName can be found. This column name does not have to be a standard learning attribute. |
AttributeValueCol | The fully qualified column name (hierarchical structure, starting from profile table) where the associated value for the AttributeName can be found. |
For example, consider the following profile table and its associated dimension table.
VisitorID | KeyField |
---|---|
1 | Key1 |
2 | Key2 |
3 | Key3 |
4 | Key4 |
KeyField | CardType | CardBalance |
---|---|---|
Key1 | Gold Card | 1000 |
Key2 | Gold Card | 9000 |
Key3 | Bronze Card | 1000 |
Key4 | Bronze Card | 9000 |
The following is a sample UACI_AttributeList table matching on card type and balance.
AttributeName | AttributeNameCol | AttributeValueCol |
---|---|---|
Gold Card | MyProfileTable.MyDimensionTable. CardType | MyProfileTable.MyDimensionTable. CardBalance |
Bronze Card | MyProfileTable.MyDimensionTable. CardType | MyProfileTable.MyDimensionTable. CardBalance |