In this recipe, we will guide you through creating a transformation that loads data from different files in your filesystem, and then load them into a MongoDB Collection. We are going to load data from files called orders.csv, customers.xls, and products.xml. Each of these files contains a key that we can use to join data in PDI before we send it to the MongoDB Output step.
Start Spoon and take a look at the content of the
products.xml files. This will help you understand what the data looks like before you start loading it into MongoDB.
You will need the
products.xml files. These files will be available at the Packt Publishing ...