Processing of inconsistencies between source and target table structures in kettle

In the process of creating the data Warehouse, you often encounter such problems, for example: the source table because of business reasons for the new field, and ETL program is extracted according to the previous source table structure, if you do not rebuild the ETL program, the new indicator will not flow into the DW, the problem is as shown in

Create a simple input and output

As shown, there is a column3 field in the source table that is not matched to the

Here we can open the SQL editor, look at the type of the field, and then add that field to the target table.

PS: Be careful to click on the Execute button in the SQL Editor, although the button will automatically add the fields that correspond to the source table to the target table, but if the target table has

The comment content will be overwritten by this operation, which simply performs a simple create table operation.

In addition , if you want the new table fields to take effect in the target table in time, you must clear the Dblink data cache corresponding to the target table .

Such as:

The first method is in the SQL editor window above

The second method is to convert the Dblink list

Processing of inconsistencies between source and target table structures in kettle