Hi All,
I have a dimension table, below :
CREATE TABLE dbo."Product_Dim"(
"ProductID" INT NOT NULL IDENTITY(1,1),
"PRODCODE" CHAR(6) NOT NULL,
"DeptCode" CHAR(2) NOT NULL,
"ProdName" VARCHAR(40) NOT NULL
.............)

Product_Dim can be 3000-5000 rows
ProductID is the Surrrogate key, ProductCode+DeptCode is the operational
key. Each department could have same code.
In the product dimension I have to use 'ProductCode+DeptCode' as 'Member Key
Column'
Fact table is joined into Product_Dim on productID.

What is the best way to create this 'composite member key column', create
New column in product_Dim ?
OR, using View as Product Dim ?

Thank you for your help,
Trist

"tristant" wrote:

Creating a calculated column will let you index the key column. Or you could create an indexed view. Either should be pretty much the same.

Regards,

Jonathan