actually I got my answer from the BroadcastHashJoin workbook. (which is Yes)