Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sireeshapulipati
Starting Member
1 Post |
 Posted - 2009-11-10 : 00:02:43
|
| I want to increase the size of my data warehouse. My professor has suggested that I create a new dimension with 5 rows and join it tot he fact table (one-to-one relationship). that makes the DW 5 times bigger.I'm new to SQL Server BI. I've created new dimension table in the data warehouse.But how do I join it to the fact table?I can only add the key column of the new dimension to the fact table by checking "Allow Nulls" - but that doesn't populate the fact table or result in a one-to-one relationship I'm desiring.So, how do I join new dimension to the existing dimensional model with all the data intact and add additional rows and column to the fact table?Please help!I'm using the sample database: AdventureWorksDWSireesha |
|
|
|
|
|
Adding a new dimension to the existing dimensional