我遇到以下情况，我需要将OLTP数据库系统转换为维建模或DWH系统。

我从来源收到了两个JSON格式的文件。它确实具有产品和审阅者详细信息。 产品：ID，名称，价格，产品URL，相关产品，销售等级，品牌，类别

Product data sample :
{
  "ID": "0000031852","name": "Girls Ballet Tutu zebra Hot Pink","price": 3.17,"urlofproduct ": "http://ecx.images-amazon.com/images/I/51fAmVkTbyL._SY300_.jpg","relatedproducts ":
  {
    "also_bought": ["B00JHONN1S","B002BZX8Z6","B00D2K1M3O","0000031909"],"also_viewed": ["B002BZX8Z6","B00JHONN1S","B008F0SU0Y","B00D23MC6W","B00AFDOPDA"],"bought_together": ["B002BZX8Z6"]
  },"salesRank": {"Toys & Games": 211836},"brand": "Coxlures","categories": [["Sports & Outdoors","Other Sports","Dance"]]
}

审阅者：ID，产品ID，名称，帮助，审阅文本，总体，摘要，unixreviewtime，审阅时间

审阅者样本数据：

{
  "ID": "A2SUAM1J3GNN3B","ProductID": "0000013714","Name": "J. McDonald","helpful": [2,3],"reviewText": "I bought this for my husband who plays the piano.  He is having a wonderful time playing these old hymns.  The music  is at times hard to read because we think the book was published for singing from more than playing from.  Great purchase though!","overall": 5.0,"summary": "Heavenly Highway Hymns","unixReviewTime": 1252800000,"reviewTime": "09 13,2009"
}

我正在努力进行尺寸建模。我可以看到产品和审阅者是两个维度。 但是我应该如何将购买，查看或购买的相关产品一起存储在我的数据仓库中。

任何人都可以帮忙吗？只是给一些想法如何进行。