How to delete data from an RDBMS using Talend ELT jobs? -

What is the best way to remove tabs using the table?

I currently with a TELTJDBCoutput removal action.

It seems that Talend is always a delete ... where it exists (& lt; your generated query & gt;) query.

So I'm thinking that we have to use the values ​​of the field or just put a fixed price of 1 (in only one area) in the teltap map mapping.

For me, by putting the actual value, it looks like useless, just where it is where it is just a matter of where it is.

Is there a better way to use ELT components?

My current job is this:

The TELTMAP component with the actual data values ​​looks like this:

But I can also do the same thing with the following configuration:

Should I put something in the fields?

The following is a demonstration of how to use ETL operations, from which data is extracted from database, read in memory, Turned up and then fed back into the database. After the clarification, opi specially wants to know how it will be different for the operation of the ELT

If you want to delete some records from a table, then you can use the normal database output components You can.

In the following example, the use case is to take some updated database and to see what records are not in the new data set compared to the old data set, and then the related data in the old data set Remove It can be used for fresh data from a live system in case of non-live systems or any other use, where you need to manually move data delta from one database to another.

We establish our job in this way:

In which two tMySqlConnection components connect to two separate databases (potentially on different hosts), which includes our new data sets and our old data sets.

Then we select the relevant data from the old data set and the internal one tamac refuses to include the new data set, any internal entry (the rows in the old data set, but the new data set Not in):

We only use the output Are interested in the key because we will be away from the WHERE query on this unique key. Also note that the key has been selected for the id field to be updated and deleted needs to be done.

And then we only need to tell Tamil that these tables should be configured correctly by configuring our tablescotal output component:

Alternatively, you can only specify some interruptions which will be used to delete records such as After you created the DELETE statement manually, after that your TMESclockOutput Component Through the main link can be fed as the key.

For example, I would like to read in the CSV with a list of email addresses, first names and last names of people who are refusing to be contacted and then make all these areas a key and Connect it to TMIsualOutput and Tallend, will generate a DELET for each line that matches the email address of the database, the first name and the last name.