Hello Friends ,
Need Help.
I do have one Huge FACT table having 7 Million Records. Data in the Fact table is like below :
NUM C1 c2 c3
1 1 2 1
1 3 2 1
2 5 2 3
3 1 2 2
3 4 1 1
3 5 1 1
Currently Table is not having any Primary Key or any Identity KeY. Dimensions Columns (c1,c2,c3,c4......c45) are mapped to their respective Dimensions.
While processing the Cube .it is taking 15-25 mints to process Full.
Please suggest ways to improve the performance of the Cube,improve fact table loading access
regds
Rakesh
Thanks
Rakesh k DHar