Unfortunately, one of the realizations I came to when creating the dynamic ETL tool was that there is a real limit to how much you can automate metadata maintenance. If you have a DW with a lot of heterogeneous metadata, and that metadata is not "slowly changing", then yes, management should either realize that schema maintenance is indeed a full-time job and pay for someone to do that, or just don't warehouse your data.

Sometimes, the right answer is "forget it".