Upserting records in a collection

This scenario applies only to 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.