I have around 10 csv files which are basically either one to many related or are many to many related. For many-many there is a csv file which stores the mapping for the two tables. I want to ingest these files into mogodb and create 1 aggregated collection. Is it feasible?
Hello @Supriya_Bansal, welcome to the community.
I have some related information to start with:
- mongoimport is a command-line tool to import CSV data into MongoDB collections.
- SQL to MongoDB Mapping Chart explains the corresponding terminology and concepts.
- For data design reference see Data Models and the blog post 6 Rules of Thumb for MongoDB Schema Design explains the modeling of relationships.
5 Likes
Thank you!! I ll look into the above links.