Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between a data warehouse and a data mart?

Answer Posted / jaya

datamart is something which consists of only one type of
data whereas datwarehouse consists of data of different
type.For example all the organisation data say data related
to finance department,HR,Banking dept are stored in
datawarehouse whereas in datamart say only finance data
will stored.So datawarehouse is a collection of different
datamarts.

Is This Answer Correct ?    19 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1956


What is freehand sql?

1050


What is the difference between connected and unconnected stored procedures?

1083


What is the difference between drill through and masterdetail reports?

1162


What are the different methods of loading dimension tables?

995


In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

1050


Can a dimension table contain numeric values?

1058


What is a cube in data warehousing concept?

1076


Explain what is fact less fact table? Where you have used it in your project?

933


What are data modeling and data mining? Where it will be used?

989


What is the differences between star and snowflake schemas?

1067


Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1132


How to create different types of templates?

987


Explain what is a staging area? Do we need it? What is the purpose of a staging area?

962


Difference between cold fusion mx 6 and cold fusion mx 7?

842