Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
You will use concatenate may you will get good result.