So I have my first data warehouse started, and generated the schema into my DB with the wizard. I noticed alll of the tables, including the main fact table has their columns allowing nulls. I dont think I want to keep it this way. So that
means I would have to script out and re-create very table, minus the null attribute, correct?
Is there anyway to change this after the schema has already been generated, other than manually?
By "manually" I mean that I would script out each table, change the null attribute, then re-create the tables with the scripts.
Instead of scripting,dropping, changing each attribute which is null to not null, and then creating the tables with the scripts, you could just go in the SQL Server Management Studio (SSMS), right click on each table you want to modify and then use the
Design functionality. There you can select in the Allow Nulls column which column should be null and which one should not be.
Also, as a word of advice, it is better to start first with the relational design of the data warehouse and then build the SSAS cube on top of it instead of the other way around. This way you will have more control over your design.
Please let me know if you have any other questions!
Per aspera ad astra!
Marked as answer byshiftbitTuesday, October 08, 2013 11:13 PM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.