| 1. |
What Is Meant By Metadata In Context Of A Data Warehouse And How It Is Important? |
|
Answer» Metadata is the DATA about data; Business Analyst or data modeler usually capture information about data - the source (where and how the data is originated), nature of data (char, varchar, nullable, existence, valid values etc) and behavior of data (how it is modified / derived and the LIFE cycle) in data dictionary. Metadata is also presented at the Datamart level, SUBSETS, fact and dimensions, ODS etc. For a DW user, metadata PROVIDES vital information for analysis / DSS. Metadata is the data about data; Business Analyst or data modeler usually capture information about data - the source (where and how the data is originated), nature of data (char, varchar, nullable, existence, valid values etc) and behavior of data (how it is modified / derived and the life cycle) in data dictionary. Metadata is also presented at the Datamart level, subsets, fact and dimensions, ODS etc. For a DW user, metadata provides vital information for analysis / DSS. |
|