makes it unlikly that you get good stats infos for the matches in the target table. In any case the concat is not the PI of the target table and therefore you can't expect a direct merge join.

Step 3 estimates 2,250 rows for the derived table after duplication to all amps. If this number is true - product join might be a good choice. If it is wrong. Collect stats and check if the plan change.