|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DATA WAREHOUSING BASICS
DETAILS
Question: What is meant by 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.
|
|
|
Category |
Data Warehousing Basics Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 8454 users |
Added on |
7/26/2011 |
Views |
70491 |
Rate it! |
|
|
Question:
What is meant by 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. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is a linked cube?
|
View Answer
|
|
What is surrogate key ? where we use it explain with example.
|
View Answer
|
|
Wht r the data types present in bo?n wht happens if we implement view in the designer n report
|
View Answer
|
|
What is data validation strategies for data mart validation after loading process
|
View Answer
|
|
What is Data warehosuing Hierarchy?
|
View Answer
|
|
What is BUS Schema?
|
View Answer
|
|
What are the methodologies of Data Warehousing.
|
View Answer
|
|
What is conformed fact?
|
View Answer
|
|
What is Difference between E-R Modeling and Dimentional Modeling.
|
View Answer
|
|
Why fact table is in normal form?
|
View Answer
|
|
What is the definition of normalized and denormalized view and what are the differences between them
|
View Answer
|
|
what is junk dimension? what is the difference between junk dimension and degenerated dimension?
|
View Answer
|
|
What is the main difference between Inmon and Kimball philosophies of data warehousing?
|
View Answer
|
|
What is the difference between view and materialized view?
|
View Answer
|
|
What are the advantages data mining over traditional approaches?
|
View Answer
|
|
What are the different architecture of datawarehouse
|
View Answer
|
|
What are the steps to build the data warehouse?
|
View Answer
|
|
What is the datatype of the surrogate key?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Data Warehousing Basics Interview Questions & Answers - Exam Mode /
Learning Mode
|