What are folks using to manage your metadata? We were thinking of possibly coming up with something custom to manage all our 10 to 12 different data sources for our data warehouse. I tried to make use of the extended properties when using Kimball templates but am finding it hard to manage updates. The Kimball excel templates created them with ease - but it's the ongoing maintenance that is difficult.
What type of meta data? I'd reccomend keeping everything in relational tables. MS Access is good for building basic data management forms in relatively small tables with fewer than 100,000 rows. The only thing Extended properties are good for in this case are column descriptions. "Joe H" wrote: > What are folks using to manage your metadata? We were thinking of possibly > coming up with something custom to manage all our 10 to 12 different data > sources for our data warehouse. I tried to make use of the extended > properties when using Kimball templates but am finding it hard to manage > updates. The Kimball excel templates created them with ease - but it's the > ongoing maintenance that is difficult. > > >
