MS SQL Data Warehousing - creating cubes without primary keys

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

creating cubes without primary keys

buddha@gardener.com

2005-09-27, 11:23 am

Hi.

I have started on a project where we have some large table where there
is no real primary key. We have 4 fields that are most likely unique
and we will assume this for our purposes.

However, there is not a primary key defined and these four fields are
propegated throughout all the associated tables.

I have never created a cube for this sort of structure. I would
appreciate some suggestions on build cubes/dimensions/data mining
stategies in this situation.

thanks for any decent ideas.

michael

Sponsored Links