As was mentioned in the explanation of the last recipe, Pentaho Instaview automatically creates ETL transformations to define data flow from the source (MongoDB in this case) to the target. Instaview gives us the ability to edit those transformations with Pentaho data integration.
This recipe guides you through editing the transformation of MongoDB Orders data source, which was created in the last recipe, in order to get better and cleaner data from the MongoDB database.
To get ready for this recipe, you first need to start Instaview with the MongoDB Orders data source, and the MongoDB server with the same database as that of the last chapter.
As with any automated tool there is always something that needs to be tweaked. Perform the following steps to make a little change to the transformation that populates data into the analysis view:
In Instaview home, click on the Open Existing button.
Select MongoDB Orders from the Data Sources...