Data migration from SQL server to mongodb

asked 2020-10-12 00:38:24 -0500

shivan gravatar image

Hi all, Im doing data migration from SQL server to MongoDB. SQL query return below response., Input from SQL query (JDBC consumer) empno | name | age | idType | idValue | lastmodifieddate 111 | Shivan |26 | pan | ABCDEF1211D | 05/01/2012 21:10:17 111 | Shivan |26 | aadhar | 112212222222 | 05/01/2012 21:10:17

Expected output { "empno" : "111", "empname" : "shivan", "iddetails" : [{ "idtype" : "pan", "idvalue" : "ABCDEF1211D", "lastmodifieddate" : "05/01/2020 21:10:17" },{ "idtype" : "aadhar", "idvalue" : "112212222222", "lastmodifieddate" : "05/01/2020 21:10:17" }] } I have tried with Field merger and field zip, there only two keys are accepting.

Please suggest. Thanks, Shivan

edit retag flag offensive close merge delete