This illustration shows data going from a source to a target:
First, the data goes to table function 1. Then it goes to table function 2 and into the target.
The data can also go from table function 1 to a staging table before going to a separate table function 3 and into the target.