My Collection is something like below:
{
"departmentCode": "1234",
"departmentLocations": [
{
"code": "USNYC",
"name": "New York"
},
{
"code": "USLOS",
"name": "Los Angels"
}
]
}
My source is an oracle table, which have reference to the location code in the above collection.
I need to read from the oracle table and upsert into the above collection as below.
{
"departmentCode": "1234",
"departmentLocations": [
{
"code": "USNYC",
"name": "New York",
"postings": [
{
"name": "Mark Twain",
"position": "Manager"
},
{
"name": "Jimmy Bourne",
"position": "Clerk"
}
]
},
{
"code": "USLOS",
"name": "Los Angels",
"postings": [
{
"name": "Harry Summers",
"position": "Operator"
},
{
"name": "Tommy Lane",
"position": "Sales Rep"
}
]
}
]
}
I obviously cannot use "departmentLocations.postings" as my Data node in tMongoDBOutput component.
Can anyone please help?
