MongoDB Output Not able to update existing Fields using _id(Object_ID) as key
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'