Most of the times for DW loading purposes when you get technical specifications sheet from BA, it will include the tables meta-data. From the spreadsheet, you can use excel concatenate to build a SQL script for the DDL statements.

Here is sample file with formulas sourced from mssqltips.com TableBuilder