Weekly 1:1

Let’s say we have 5 metrics:

Initial thought process was to have 5 columns, for each of the metrics Since we are replicating the records across all of the tables - table size increases

Option 1 ASIN DIMENSION Metric facts are separate, whenever you build a query, you join on the metric facts and create the output

Option 2 ASIN -> Title, Product Group, Price (Standard dimension) For conversion, we will create a conversion column, and will have a JSON blog in here. For idq, we will have a JSON, etc etc

---

uid: 202007241000 tags: #meetings #amazon

---

---

---