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

 Print  |  
Question:  1).briefly state different between data ware house & data mart?

2).How are u going to consolidate customer infromation in dataware house from the three different back end OLTP applications?
3).What is meta data?




October 10, 2006 11:45:43 #7
 jessa   Member Since: Visitor    Total Comments: N/A 

RE: 1).briefly state different between data ware house...
 

datawarehouse: intergrated,relevant  data(subject oriented) from different sources  are put together to a data base for business decisions. these data is appended as time goes by keeping historical data (of a certain time period). this kind of a db is a datawarehouse..( u have to imagine a big concern). this warehouse will have data about the entire business.

datamart : its like a datawarehouse for a particular department. hence they contain data relating to that dept only.

u can bring data from these sources thru native drives or other methods and clean the data(profile, analyse etc) transform them if needed and load to the dw.

meta data is data about data...eg this is wer the data is , col def of the table, it contains primitive data types etc..

     

 

Back To Question