Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 4 tables in Oracle with 1 -> N relation ship.( one customer has multiple addresses and multiple Emails, and Multiple Phone numbers).
I want to take the data from above tables and insert into MongoDB Collection with below structure.
{
"Customerid": "100",
"CustomerName": "XXXX",
"type": "Retail",
"Addresses": {
"Address": [
"Address_ID": 1,
"Address1": "Local",
"City": "Lowell",
"State": "MA",
"Zip": "123456",
"Country": "USA"
},
"Address_ID": 2,
"Address1 ": "Local",
"City": "Shrewsbury",
"Zip": "75248",
}
]
"Emails": {
"Email": [
"Email_ID": 1,
"Email": "abc@gmail.com"
"Email_ID": 2,
"Email ": "xyz@hotmail.com"
"PhoneNumbers": {
"Phone": [
"Phone_ID": 1,
"Number": "123-456-1234"
"Phone_ID": 2,
"Number ": "123-456-1234"
Can Someone help me how to do this?
Thanks,
Surendra