Upserting records in a collection

This scenario applies only to subscription-based Talend products with Big Data.

For more technologies supported by Talend, see Talend components.

This scenario upserts the collection blog as an existing record has its author changed and a new record is added. Before the upsert, the collection blog looks like:

1;Andy;Open Source Outlook;Open Source,Talend;Talend, the leader of the open source world...
2;Andy;Data Integration Overview;Data Integration,Talend;Talend, the leading player in the DI field...
3;Andy;ELT Overview;ELT,Talend;Talend, the big name in the ELT circle...

Such records can be inserted to the database following the instructions of Creating a collection and writing data to it.