CODEWITHSUNDEEP
talend
Velikovsky
Velikovsky

Reputation: 13

How to know in Talend if tMySQLInput will overwrite data?

I have one already existing Talend Open Studio tMySQLInput component with some sql code inside it, in order to retrieve some joined columns linked to a tMySQLOuput component (pointing to an already existing MySQL table) with few records.

QUESTION: Will the "tMySQLInput" component overwrite the already existing table data that the tMySQLOutput component relates to? I mean is there an option to check in the tMySQLInput our output in order to say, overwrite each time this job is executed ?

Thank you all.

Upvotes: 1

Views: 229

Answers (1)

GadaaDhaariGeek
GadaaDhaariGeek

Reputation: 1030

Yes, there is an option where in tMySQLOutput where you can specify what action you want to do to your table. Follow following steps:

  1. Go to component tab of tMySQLOutput, it will open the basic settings of this component.

  2. If you will look closer you will find Action on table. This is the action which you can perform on the table which is pointed by tMySQLOutput. It has options as Default, Drop and Create Table etc.

  3. Then you have Action on data. These are the options which you can perform on the data like Insert, Update etc.

In your case I suppose you can choose Action on Table as Default and Action on Data as Insert. Default action would not do anything on the table and Insert option would insert the records at the end of table. But in case of Insert if you will have duplicate rows then job would stop the moment it will find any duplicate row.

Upvotes: 1

Related Questions