MongoDB does not have foreign keys. You can add to the referencing object an attribute with the ObjectID of the referenced object, but this does not cause a referential relationship like in relational databases. Please refer to this article to get an idea what is to do: http://stackoverflow.com/questions/6334048/foreign-keys-in-mongo
I have gone through the information you have provide and found them very useful. Somewhere I had learnt that GUI based talend can also help in data migration. So I was curious to know how I can exploit talend for this purpose. Thank you for your reply.
Hi friends, I have installed mysql and mongodb in Amazon Web Server for the migration process. How can I use talend for writing to mongodb from mysql if 1. talend BD is installed on my desktop 2. talend BD is installed in AWS. I donot see any component for connecting to AWS. Will appreciate if I can have some tutorials. Pl help. Thnaks, Sushant