I have to slice sales by order date, scheduled delivery date, and actual delivery date. I would think that would require three different date...
When you partition data in your OLAP do you partition fact table and all dimensions or just the fact table? I am going to have at least three...
I've found these helpful: Delivering Business Intellignece with Microsoft SQL Server 2005 by Brian Larson Foundations of SQL Server 2005 Buisness...
Nearly everything I read tells me to use integer surrogate keys for the dimension tables, combine all surrogate keys as the composite primary key in...
The OLTP db will have several million rows, several hundred thousand new rows a day, so I'm thinking performance is going to be a rather large...
I have a factSales table and a dimCustomer table (among others); all my data is coming from a single OLTP SQL Server db. When loading data do I parse...
D'OH! PK doesn't enforce uniqueness on individual cols only the combination of all cols in the composite key. Back to the drawing board..........
"The columns in the table 'Order' do not match an existing primary key or UNIQUE constraint." Both tables have compoist primary keys.
I really just need to know if there is a way to establish an FK relationship between individual columns that are both part of composit keys in their...
I have three tables that I want to link for a many to many relationship: sales: Type, int, PK Cust, int, PK Order, int, PK .... Order: Order, int,...
Separate names with a comma.
