GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Concepts
Go To First  |  Previous Question  |  Next Question 
 Concepts  |  Question 23 of 29    Print  
definition of datamarts?

  
Total Answers and Comments: 4 Last Update: May 25, 2007     Asked by: sivanov21 
  
 Sponsored Links



 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 15, 2006 06:16:37   #1  
sudhakar        

RE: definition of datamarts?
DataMart is the subset of datawarehouse. you can also consider datamart holds the data of one subject area. For an example, you consider an organization that has HR, Finance, Communications and CorporateService divisions. For each division you can create a datamart. the historical data will be stored into datamarts first and then exported to datawarehouse finally.
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
January 29, 2007 04:09:15   #2  
anilreddy27 Member Since: January 2007   Contribution: 2    

RE: definition of datamarts?
Datamarts are the partitions of the overall datawarehouse. Datwarehouse covers as every aspect of the company's business, then datamart is a subset of that huge datawarehouse.Datawarehouse is limited to the resource constraints and priorities of the MIS organization. But, the task of the implementing Datwarehouse needs big effort and takes significant amount of time. It Impacts on return on investment.So, the feasible option is to start a set of datamarts for each of the component departments.Simply, we can say a set of small, more managable databases are called datamarts.2 types of datamarts are there.1. Standalone datamarts: It enables a department or workgroup to implement a datamart with minimal or no impact on the Enterprise's operational database.2. Dependant datamarts: Enterprise database is required for these marts. Datasources includes operational databases and external sources of data.
 
Is this answer useful? Yes | No
February 01, 2007 16:25:01   #3  
mahesh4346 Member Since: January 2007   Contribution: 6    

RE: definition of datamarts?
Data marts are subset of data warehouse. It is the Repository of data designed to answer specific questions to a specific set of users. It is also subject oriented, and an organization can have multiple data marts. It is also used for specific reporting and analysis.
 
Is this answer useful? Yes | No
May 25, 2007 00:16:16   #4  
sivakumar.p        

RE: definition of datamarts?
Data Mart is subset of dataware house deal with single area of data and is organized by quick analysis.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links



 
Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape