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

Hi Rakesh,

Would incrementally processing be an option? https://bennyaustin.wordpress.com/2011/10/29/ssas-process-incremental/

Hello Jorg,

Yeah , That can be as an Option . But my Team mates want to know the SQL DB Side as well..

What can be done in the FACT table(indexes/primary key/or any other) so that the data can be fetched Fast )

Thanks

Rakesh