How to update 2 columns in mongo effectively without changing any values of other columns

[krengan21]

Hi ,

I have designed one job for upserting the data in a collection of mongodb using the option upsert with set in mongodboutput component.There are totally 216087 records to be updated it is taking almost one full day to complete .Any other possible easy way to update the records in less amount of time? 

[Anonymous]

Hello,

Here exists tMongoDBBulkLoad component which reads data from CSV, TSV or JSON files and imports them into the specified MongoDB database.

Could you please have a look at this related scenario about:TalendHelpCenter: Scenario: Importing data into MongoDB database.

Let us know if it is Ok with you.

Best regards

Sabrina