Post reply

Meta Data Management

  • May 16, 2007 at 3:55 pm

    #172505

    Hello,

    I am looking for some best practices of managing meta data. Right now with one of our client the meta data is stored in multiple places like spread sheets, in some ETL tools, word docs.

     

    I am looking for good way to centralize this meta data , which would be easy for business analysts, ETL developers to query and modify.

    Any help in this regard is welcome.

     






    Regards,
    Sudheer 

    My Blog

  • May 30, 2007 at 3:01 pm

    #709823

    I tried to do the meta data long time ago.  It is basically a full time job. Everytime something changes, you have to change the meta data.

    I used to do some meta data work, not all of them, here was the list.

    Document all the source data, where they came from, the format of each field, the possible values of each field.

    Document the dimension tables and fact tables - each field. 

    Document which source data field went to which table in the data warehouse.  Is there any translation from the source data to data warehouse data?  Is there a default value if the source data did not exist?  Any error report produced?

    Document each business rule when building the data warehouse.

    These are just the basics of the meta data management.

     

  • May 30, 2007 at 4:28 pm

    #709844

    Thanks for that.






    Regards,
    Sudheer 

    My Blog

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply