把source表的内容输入到target表里面 每一条source记录都会复制到target里面
Append the fields from a source input to every record in a target input. Each record of the target input will be duplicated for every record in the source input.
笛卡尔连接 S:3 T:4 最后 3*4=12
The result is a Cartesian Join where all records from both inputs are compared
比如:
一般来说 Target是大的数据源
Source是小的数据源
Target (T) input contains 16 records with 5 data fields; Source (S) contains 5 records with 3 fields. The output generated from the Append Fields contains 80 records with 8 fields
16*5=80 record
5+3=8 field
The user can configure warnings or errors to be reported to ensure too many records are not produced. Choices include:
Error on Appends of more than 16 records (Default ): If more than 16 records are in the Source file (S input) an error will be reported in the Output log and the workflow will stop processing.
默认:当source>16条记录的时候 error就会弹出 停止运行-----这时候可以在configuration里面勾选16条的那个记录
Warning on Appends of more than 16 records: If more than 16 records are in the Source file (S input) an Warning will be reported in the Output log and the workflow will continue processing.
Allow all Appends: All records will be appended to all records with no error or warning.