Data Warehousing Basics Question: Download Questions PDF
What is metadata in context of a Datawarehouse and how it is important?
Answer:
Meta data 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, existance, valid values etc) and behavior of data (how it is modified / derived and the life cycle ) in data dictionary a.k.a metadata. 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.
Download Basics Data Warehouse Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is static and local variable? | Suggest a good author for Hyperion in data warehousing? |