topic Data Updation based on a Category in Talend Studio

Data Updation based on a Category

Jebin97 — Sat, 16 Nov 2024 00:29:00 GMT

Hi There,

I want to update a group of values based on a category but not on the primary key.

Consider I have a dataset with 50 rows and the data is categorized into 5 groups, While inserting the data into the DB it should check whether there is data related to the inserted category, if yes then the data related to that category should be dropped and new set of values should be inserted.

How should I write a logic for this.

Input & Output DB: Snowflake

Re: Data Updation based on a Category

Anonymous — Mon, 08 Mar 2021 04:17:30 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Data Updation based on a Category

Anonymous — Mon, 08 Mar 2021 06:52:29 GMT

@Jebin Atheesh P L , you meant all the existing data related to that category in DB will be dropped? and then insert new set of values?

Regards

Shong