Can we join multiple children to a single parent node using only one Tree Join transformation object?

A Tree Join transformation object can only be used to join a parent node with a single child node. In order to join multiple children to a parent, multiple Tree Join objects can be used sequentially.

For example, here we have Orders as the parent, and we wish to join two children, Customers and Order_Details. We can do that by joining Customers and Orders in the first Tree Join 1, and Order_Details and Orders in the subsequent Tree Join 2.


Visit Tree Join Transformation to learn more.