Currently stored procedures can be loaded to the data mart through a spec by specifying a mart key. The actual tables, however, are still left to a revision. Adding a special table spec would make management and deployment of the BBDW simpler and keep the projects tidier. Rather than 3 projects for custom BBDW tables (a catalog for stored procedures, a revisions project, and an SSIS project) you could just maintain 2 (catalog and SSIS). Extended properties could also be semi automated, taking the description from the spec and generating the foreign key extended property in a standardized way.
|Organization Name (Please enter full organization name)||Memorial Sloan Kettering|