I have master detail fact tables. due to some reason I want to concatenate both of them in one table. I did this by using Concatenate command. the problem is CustomerID is present in all Master Rows and not in Detail rows. How to update CustomerID in all rows of a Order?