In this recipe, we will guide you through creating degenerate customer and product dimensions. A degenerate dimension consists of a dimension that doesn't have its own physical table, and the data lives in the fact table. In other words, the customer and product json are sub-documents within the Order
documents of the Orders MongoDB collection.
Before you start this recipe, you need to make sure you have the MongoDB databases created in previous chapters. Also, the Data Integration server should be running, and you will need the schema that you created in the previous recipe.
Proceed with the following steps:
Let's add the Customer dimension to the Orders cube: