I need some help with my internship project please.
The company in which I'm doing my internship is changing the tool that manages all the data. As a result of that, they want me to do a data mappin.
After doing some research of this subject, I understood that data mapping was a way to link the different data to better target them and not creating a map with all the data represented on it as I thought in the beginning. The problem is that I don't know how to proceed.
First, I thought about the following steps:
- Study the data that are stored in the software that manages the database.
- Export the data I need (Using Business Object or Toad since they give me access to them)
- Clean the data exported (Using OpenRefine or manually by using Python)
- Mapping the data
I do not know if these are the right steps to follow.
Then I looked for open source tools to do the mapping directly but unfortunately I didn't find what I was looking for.
thank you for your help