Move table creation from revisions to table specs

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. 

  • Tommy Tavenner
  • Sep 19 2018
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) Memorial Sloan Kettering
Reported Version 4.0
  • Attach files