I have a hypothetical scenraio where, if i have a hundred different inputs for a Union:
Would it be better to connect them all to a single Union tool?
OR
Would it be better to connect bunches of 10 to one Union tool, and then connect these 10 Unions to one final Union.
My question is from performance perspective, with reference to a post on the community where it was mentioned that it is better to have multiple Filter tools in succession rather than have one Filter tool with multiple clauses.