Series: Subject: Topic:
Question: 81 of 200

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

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 qualitySome 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



twitter fb Linkedin GPlus RSS


Question Categories

Abinitio Interview Questions

Analysis services Interview Questions

Data Warehousing Basics

BO Designer Interview Questions

Business Intelligence Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Data Warehousing Concepts

BO Data Integration

DataStage Interview Questions

ETL Interview Questions

Hyperion Interview Questions

Impromptu Interview Questions

Informatica Interview Questions

MicroStrategy Interview Questions

Reportnet Interview Questions

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.