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

What is best institute to Learn DotNET And SQL in chennai?

2163


What is the importance of three tier architecture?

1093


Explain magic tables in sql server?

1060


What is transact-sql language?

1095


Does an index slow down updates on indexed columns?

974


Difference between drill down and drill through report.

957


What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1063


What is cdc in sql server?

1001


How to loop through returning rows?

1036


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

964


How many categories of data types used by sql server?

1020


Explain the architecture of ms sql reporting service?

922


What are the types of indexing?

1084


Define union, union all, minus, intersect?

980


Explain filestream storage of sql server 2008?

1016