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 an inner join?

1041


Explain in brief how sql server enhances scalability of the database system?

1028


What is a covered index?

987


Explain external key management in sql server 2008

937


Introduction of rollup clause using sum and group by clause?

1014


What is the correct order of the logical query processing phases?

996


How to create a user name in a database?

1103


What it means to be triggered?

1082


Explain multiserver query

1113


What is the recovery model?

1061


What are out-of-range errors with date and time literals?

1094


Do you know how to implement service broker?

973


How many databases instances are there in sql server 2000?

1168


Can two tables have the same primary key?

1267


Explain the difference between control flow and data flow?

1061