Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone
My Talend Job has InputFile-->Tmap-->MongoDBOutput. As part of the job i am trying to update existing Subelement Field level values with new values using _id(ObjectID) as key.
Could you please let me know what option do i need to use.
i tried option 'set' or 'Upsert with Set'. But no records got updated.
I can't use 'Update' or upsert:since this will replaces the existing document and source and target layout is not same Source has only 10 Fields But Target collection as 50. Out of 50 Fields i need to update only 10 fields so i had to use 'set' or 'Upsert with Set'.
I appricate all the help if you could help me in this issue.
Settings inside the MongoDBOoutput that i am currently using.
Basic Settings : Bulk write & Bulk Write Size " 1000" & Action on data 'Set'
Advanced settings : GenerateJSON Document &
Ignore Service attributes for empty elements
Remove root nod.
Data node as "data" & Query node as "query"
Also i have Configure Json Tree similar to below