DataModelling

[deepakqlikview_123]

Hello All,

PFA.

I have total 8 fact tables.

4 is for row indicators and 4 for derive indicators.

Tables are same there structure is also same.

In data modelling side only concatenation for 8 fact tables will be better or not.

What will happen if i can use join.

Please advice.

[#2]

Hi

   If Dimensions are same then go for concatenate because if u use join that will effect on your application performance

       concatenate it will append the data table by table

      Join it will  add filed data in side by side

Thank

Manju

[#3]

Hi,

  You will use concatenate may you will get good result.