I have this meta data just for research purpose that I received from an external system. It will not be used for any processing only research and it would be...

Hello,

Thank you all for the replies. Yes the current DataWarehosue is not properly normalized. We are currently working on the new design. We also did think about creating a bucket...

Thank you!

Hello,

sorry I thought I responded to your question, but i just noticed i did not.

there are a total of about 60 measures. Most measures are basic. There are some that...

Hello,

It will be 50 to start, but will grow. They are all a part of the same process and grain.

thank you,

m

Thank you all for the suggestions. I will consider them.

Thank you guys for the replys.

Unfortunately, in the current table we do not have a date column that we can use. I am assuming that the designer of the table...

Hello,

Does anyone have any ideas on the copying of the data in my situation?

Thanks

Hello,

1st of all sorry for creating a duplicate topic it was an user error. I noticed it only after I created the 2nd. I was not able to...

The Heap table does not have an Id column only the partioned table does.

thanks for the input.

I appreciate your help.

Period is like a Month, currently we have about 280 periods and the system will have a total of 508 periods. Door_id is like an account number.

Usually...

they compromise the natural (primary key)

Good morning. So does anyone have any idea that could help on what are the best methods for deciding how to allocate files\filegroups? Does anyone know if there are any...

this is the current table. I will have to keep it mostly as is. I will be adding a unique_id, create, and modified dates at the bottom. "period" will be...

For ease of moving them around if needed. What would you recommend given the size and amount of data?