I am working on to create a data warehouse. I have made a database which will be the data warehouse and will consist of dimension and fact tables. I know that other than dimension and fact table a data warehouse should also consist of a meta data, now my question is what should be the structure of metadata and all the information it should have?
What about having Azure Data Catalog capture the table and column names and let developers and business users collaborate on the definitions in a UI? This would be a great data dictionary. http://azure.microsoft.com/en-us/services/data-catalog/
Or if you want to roll your own with extended properties you might do the following: https://www.mssqltips.com/sqlservertip/1637/script-to-build-a-sql-server-data-dictionary-and-report-with-microsoft-excel/