Problems encountered in kettle Recordset connection components
Description
At the beginning, the record connection component encountered a problem. There were corresponding records in both AB collections, but the data field in the B collection could not be fetched after the connection.
As shown in the following figure:
Master table record set output A
Secondary table record set output B
Recordset connection output
You find that the actual records do not get the corresponding value.
Solution
After troubleshooting the SQL problem, I suddenly realized that there might be something special about this component, so I clicked on tips and found the problem: the input streams of even join must be sorted by associated key.
