A customer has an eCommerce site and Imports data into three data extensions daily; 'Orders', 'Order_Details' and 'Products' the data extension contains the following information:
* Orders: OrderId, CustomerId, OrderNumber, OrderDate, OrderTotal, GrandTotal
* Order_Details: ProductId, OrderId, Qty, UnitPrice, ExtendedPrice, Discount
* Products: ProductId, SKU, Name, Description, Cost, Price
What two actions should be taken in Data Designer?
- Create a one-to-one relationship between Orders and order_Details
- Create a one-to-one relationship between the contact record and Order_Details
- Create a one-to-one relationship between Order_Details and Products
- Create a one-to-many relationship between Orders and Order_Details
Reveal Solution Next Question