Hi,
I was looking at this document.
https://help.talend.com/search/all?query=tMongoDBOutput&content-lang=en
I am not able to understand how exactly to use data node and query node here.
Also, the tMongoDBOutput component requires the schema to be same as input schema.
I have the input coming from a sql schema as:
Name, DOB, class, subject1_marks, subject2_marks,subject3_marks, average_marks
I want to frame a json in my mongoDB like:
{
_id:{ name:"abc", DOB:"26-01-1947"},
subjects:
}
Also i want to perform upsert operations where i can update marks for specific subjects and add additional fields like
{
_id:{ name:"abc", DOB:"26-01-1947"},
subjects:
}
How to do this?
I see upsert option but am not able to use it. Also how to use properties of mongo like $push and $set here.
Thanks!