kettle节点介绍（壶节点介绍）.docVIP

kettle节点介绍（壶节点介绍） A. Transformation 1. table entry You can write SQL statements through table entry, introducing data content that you want to query and convert. 2. valued mapping The value of the corresponding field can be converted to the corresponding standard by means of the value mapping. 3. increase constants Adds a fixed value column to the data entered from the table. 4. get system information Information from the system can be added to the input data by obtaining system information. System time. 5.Modified Java Script Value Control the output field value by writing the corresponding JS. Can format conversion, data modification, etc.. 6. remove duplicate records Duplicate records can be filtered to retain only data content. 7. table output Output the corresponding data to the specified target table table in accordance with the matching principle. 8.Json output Output the corresponding data to the specified location according to the JSON standard. 9 call the DB stored procedure You can call the stored procedure established in the database. Automatic increase, such as ID. Note that there is no need to add a return value. 10.JSON Input JSON object file input. You can read documents written in accordance with the JSON standard. 11. generate records In JOB, if you do not have input, you need to add a build record as the start of the transformation. Property limit is set to 1. 12. add sequence In the data table data, one column can be automatically added for the data as an increase in the automatic ID. The contents of ID can be obtained from the database or automatically added. 13.Simple evaluation Judgement condition of cycle. In JOB, you can join JOB as judged by the need to cycle. 14.Generate random value Automatically add a column of information in the input stream. The information content can be specified as UUID equivalent. 15. calculator Generates new values and corresponding columns by merging column values. 16. split fields The composite fields in the dat