GeekInterview.com
Series: Subject: Topic:
Question: 47 of 82

Meta Data and Data Dictionary

What are the differences between Meta Data and Data Dictionary?
Asked by: maheshdurai | Member Since Feb-2008 | Asked on: Feb 17th, 2008

View all questions by maheshdurai

Showing Answers 1 - 2 of 2 Answers
pal.amol

Answered On : Feb 26th, 2008

View all answers by pal.amol

HI 
 
Metadata is nothing but the data about data , if you take term of informatica in that through metadata only you will be converting or solving the problem. In the flow of Informatica mapping real data will first convert in to metadata which is not actual data and then it will be converted to again metadata to data , that is the way how metadata works in datawarehouse.
  
Data Dictionary is the tool where you can find views,tables,restrictions,alias and etc data base activities in perticular datawarehouse.

  
Login to rate this answer.

The “data dictionary” in a database tool (eg. Oracle or Informatica) is simply a repository of metadata.

Metadata is however data about the data.  The following are examples of metadata:-

  • The structure of each of the Dimension and Fact tables, including the Primary Key, Natural (or business) keys and any hierarchies implicit in the data.
  • For each Fact or Dimension table the record of the number of rows loaded, when they were last loaded, and indications of the data quality
  • Some systems capture data at different time points from several systems, and use metadata to “release” a consistent set of data.  Equally the metadata is available for query, so users may see for example that the SALES records from Northern Division are correct to last night, but Southern Division are loaded to last week.  This means the data is correct within Division, but cannot be calculated correctly to date.  Ie.  Total sales are only valid up to “last week”.
  • Every Dimension table may hold “groups” of columns.  For example a SALES_REGION_ID, SALES_REGION_NAME, REGION_LONG_NAME, REGION_POPULATION.  Some systems hold metadata about the relationships between these, so they are always held consistently (eg. Region 24 cannot have the name for Region 25).

 
In short the data in the data dictionary is an example of Metadata.  However, most people see “metadata” as additional information over and above the basic structure – information which adds value to the data in the warehouse.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Business Objects FAQs

Cognos FAQ

ReportNet FAQ

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.