Concatenate master detail fact tables

[#1]

Hi

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?

Regards

Rizwan

[salto · Accepted solution]

Hello Rizwan,

     I suppose you have a field that links both Master and Detail Rows.

     In such case, maybe a left join Master -> Detail can be a good option, instead of concatenating both facts table. Then every row (Master and Detail) will have the CustomerID field informed.

Hope this helps!

[AbhijitBansode]

Use Join instead on Concatenate

[#4]

Thanks to all

The issue is resolved with Left Join.