Expand my Community achievements bar.

Data Modeling Query

Avatar

Employee

I need help with one of the questions from AEP certification! I will try to recollect the question along with the options given.

Q: 'Order' and 'Item' tables are given. Here are the table details:
Order Table (Id, Date, Customers, etc)
Item Table (Order Id, Item Id)
What is the best way to model it?

a) Model Order table as an XDM Experience Event class-based schema and Item table as Custom class
OR
b) Model as an XDM Experience Event class-based schema

3 Replies

Avatar

Community Advisor

@shaunakj18  The question is missing some context around how this data model will be used for segmentation or in an use case. Depending on this information the answer can change.

 

But I would pick A as answer. Order Table will be create as a XDM Experience Event Class Schema and item table will be a look up customer class.

 

Here is a screenshot of similar setup

 
 

media_103696e65fd22011fa4f7281179fe5a742fa88005

 

 

 


     Manoj
     Find me on LinkedIn