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
What is an inner join?
Explain in brief how sql server enhances scalability of the database system?
What is a covered index?
Explain external key management in sql server 2008
Introduction of rollup clause using sum and group by clause?
What is the correct order of the logical query processing phases?
How to create a user name in a database?
What it means to be triggered?
Explain multiserver query
What is the recovery model?
What are out-of-range errors with date and time literals?
Do you know how to implement service broker?
How many databases instances are there in sql server 2000?
Can two tables have the same primary key?
Explain the difference between control flow and data flow?