I know, this is something that should be done at the level of the data model as a star Schema but in this specific case it is not possible. I have 1 dimensional table and 4 transactional tables. All of them have the 1 unique column (order number). Is there any way to get 1 huge table without joining them together step by step and expanding them? Is there a way to do it all in one step?

In the future this will be done in the Warehouse but for now this will work as a proof of concept for several months.