|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DETAILS
Question: What’s metadata? What’s a data dictionary?
Answer: Metadata is data about data. Metadata gives you data element definitions, data layouts, and information about the data element’s location. Data elements are the smallest unit of data that can be described, for example the zip code field within an address database record. The University’s data warehouse refers to their metadata as data dictionaries. You can access the data dictionaries on the IDEA web page . Click on the Information button, then click on the Data Element Dictionary for the database of your choice.
|
|
|
Category |
Data Warehousing Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8403 users |
Added on |
8/27/2014 |
Views |
68213 |
Rate it! |
|
|
Question:
What’s metadata? What’s a data dictionary?
Answer:
Metadata is data about data. Metadata gives you data element definitions, data layouts, and information about the data element’s location. Data elements are the smallest unit of data that can be described, for example the zip code field within an address database record. The University’s data warehouse refers to their metadata as data dictionaries. You can access the data dictionaries on the IDEA web page . Click on the Information button, then click on the Data Element Dictionary for the database of your choice. 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 |
|
Definitions of decision tree on the Web:
|
View Answer
|
|
Why would I want to access the data warehouse when I have a mainframe computing system?
|
View Answer
|
|
What kinds of data belong in a data warehouse?
|
View Answer
|
|
Data Warehousing - Introduction
|
View Answer
|
|
How can u recover the session in sequential batches?
|
View Answer
|
|
What r the joiner caches?
|
View Answer
|
|
In Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?
|
View Answer
|
|
How to use mapping parameters and what is their use
|
View Answer
|
|
What is difference between stored procedure transformation and external procedure transformation?
|
View Answer
|
|
Can u copy the session to a different folder or repository?
|
View Answer
|
|
What is a time dimension? give an example.
|
View Answer
|
|
Explain about Recovering sessions?
|
View Answer
|
|
Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?
|
View Answer
|
|
What are the types of External Loader available with Informatica?
|
View Answer
|
|
How many ways U can update a relational source definition and what r they?
|
View Answer
|
|
What is the approximate size of a data warehouse?
|
View Answer
|
|
What is a data mart?
|
View Answer
|
|
What are the benefits of data warehousing?
|
View Answer
|
|
What is OLTP?
|
View Answer
|
|
What are dimensions?
|
View Answer
|