Thanks for hanging in there with me. The closing statement on the DBCC are as follows:

CHECKDB found 0 allocation errors and 11 consistency errors in database 'MB_DW_USA'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MB_DW_USA).

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

As I stated above, we would prefer to solve this without taking a 5 hour outage to repair with data loss. Its a big deal to the users that the DB remain online if at all possible.

How about simply truncating the table? Not even dropping it?