LID Methodology
Label
lecture lab details label the tables from the connection 5g data warehouse erd and streaming erd with the appropriate xdm class label for individual profile, experience event, and lookup tables keep in mind the following when performing the lab individual profile (traits) – uniquely describes the traits of a person (e g name, email, address, preferences, etc ) experience event (behaviors) – describe interactions and touchpoints a person has with a brand/company (e g web page visit, purchase, call center interactions, application submit, etc ) lookups (supporting) – provide additional contextual information in support of the individual profile or experience event step 1 label xdm individual profile tables identify all the source tables which represent an individual person in both the customer data warehouse erd and the customer streaming erd mark each table with a “ p ” signifying it is part of the xdm individual profile class only mark the tables which uniquely represent an individual person's traits step 2 label xdm experience event tables identify all the source tables which represent the behavior of an individual person in both the connection 5g data warehouse erd and streaming erd mark each table with an “ e ” signifying it is part of the xdm experience event class only mark the tables which uniquely represent an individual person’s behavior step 3 label xdm supporting tables identify all the source tables which represent lookup data and are directly related to either a “p” or “e” table you have marked in either the connection 5g data warehouse erd and streaming erd mark each table with a “l” signifying it is part of a non person custom xdm class lookup tables can only be 1 join level or "hop" away from either a “p” or “e” labeled table review