Hi guys, I need some advice. I must create a cube from a huge table, and that's ok, no problem. The point is that I got only this huge table, no others table with the dimensions. Just customer, country, product, line, quantity, amount etc. in one table. I got two solutions in order to build a schema. Solution 1 using SSIS I can create automatically seven or eight dimension tables that I can use as data source (keeping the huge table as fact table). Solution 2 instead to create the tables I can create seven or eight views using them sa my dimension table data source (keeping the huge as fact table). I am a little bit afraid about the circular relationship.

Any advice? Can I use both or it's better using only the Solution 1?

Thanks

 

Use views.  I use them extensively and it works fine.

Make sure there are indexes on your dimension fields and use the "WITH (NOLOCK)" hint.

• Marked as answer by DIEGOCTN 1 hour 51 minutes ago

Cheers Tom. There are no indexes in the table, it's a data warehouse table with no transaction. Anyway, yes. I'll try with the views.