As a Model Builder, I want to join multiple sources in one single step so that I can accomplish my tasks with as little ETL footprint as possible and have a more intuitive ETL Flow Graph.
Often there are multiple sources where values have to be retrieved from. Currently you either have to do multiple joins one after another to gather all the values or you have to define several lookup functions in a field transform. The latter seems to be less performant than table joins (when multiple values/columns of each source are needed).
A new type of transform should be introduced where multiple joins can be done. One source could be joined with multiple other sources. For each of the other sources the join type and columns should be defined.
