You are building a Job to run outsode Talend Studio that must run on both Linux and Windows.
Which action should you take when building the Job?
The tMysqlOutput component is used to write data into a MySQL database table. The Action on table parameter of this component allows you to specify what operation to perform on the table before loading data into it. The Action on table parameter supports the following operations:
Drop table if exists and create: This operation drops the table if it already exists in the database and creates a new one with the same name and structure as defined in the schema.
Create table: This operation creates a new table in the database with the name and structure as defined in the schema. If a table with the same name already exists, an error will be raised.
Create table if does not exist: This operation creates a new table in the database with the name and structure as defined in the schema only if there is no table with the same name already existing in the database. If a table with the same name already exists, no action will be taken.
The Action on table parameter does not support the following operations:
Replace: This is not an operation on the table, but on the data. The Replace parameter of the tMysqlOutput component allows you to specify whether to replace existing rows in the table with new rows based on a key attribute or to insert new rows only.
Elza
5 months agoAllene
5 months agoKeneth
5 months agoBrittani
5 months agoGayla
6 months agoNguyet
6 months agoEulah
6 months agoCeola
6 months agoVanesa
6 months agoTracie
6 months agoTorie
6 months agoVeronika
6 months agoNickolas
7 months agoDeandrea
7 months agoXenia
11 months agoJoaquin
11 months agoJeffrey
10 months agoRickie
10 months agoChauncey
11 months agoZona
11 months agoGlendora
11 months agoAshlyn
11 months agoLili
11 months agoHarrison
12 months agoAshton
10 months agoSherly
11 months agoHector
11 months agoAn
1 year agoJames
11 months agoOcie
11 months agoCarline
11 months agoDong
11 months agoAnthony
1 year agoMozell
1 year agoShelton
1 year ago