Kettke how to implement a field for the first time synchronization data, later synchronization does not cover or changes in the field, it means that, I'm from a table to all of the data synchronization to b table, kettle run every hour, but the b table when one of the field data is empty, if after synchronization to the data, the value of this field no matter how to change a table, I have to b table this field is always a first time synchronization to the value, can be achieved

CodePudding user response:

You can use the primary key judgment, if a table has b table data, then the data is inserted into the table b, if a table has b table also have, do not insert,

CodePudding user response:

Can set a temporary table, the data extraction to the temporary table, first the target table of existing data in the temporary table is deleted, and then from a temporary table to the target table number

CodePudding user response:

reference Lao wang to go to the second floor response:

can set a temporary table, the data extraction to the temporary table, first the target table of existing data in the temporary table is deleted, and then from a temporary table to ask target table number

thank you