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

Explain fundamentals of Data ware housing & OLAP?

Answer Posted / radhakrishnan vaithilingam

Dw:historical data for related application and this is
support to decision making system.

Eg: sales manager check the total sale details for all
loaction. every location using seperate database. so we
need to merge all data in one database.

- we can use star schema or snowflake shema

OLAP : online analtical processing.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain concepts of analysis services?

928


Explain alternate key, candidate key and composite key in sql server?

893


What is 'Join' and explain its various types.

1116


What is the primary use of the model database?

1065


Where can you find the error log information? : sql server database administration

1003


What is an indexing technique?

906


What is compression - row-level and page-level compression?

895


How to encrypt data between dialogs?

1076


What is a data collection table?

985


How many joins in sql server?

929


What are the different Topologies in which Replication can be configured?

1164


what is an extended stored procedure? : Sql server database administration

1033


What is the xml datatype?

1025


Can you type more than one query in the query editor screen at the same time?

989


How to rebuild all indexes on a single table?

1037