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
Explain concepts of analysis services?
Explain alternate key, candidate key and composite key in sql server?
What is 'Join' and explain its various types.
What is the primary use of the model database?
Where can you find the error log information? : sql server database administration
What is an indexing technique?
What is compression - row-level and page-level compression?
How to encrypt data between dialogs?
What is a data collection table?
How many joins in sql server?
What are the different Topologies in which Replication can be configured?
what is an extended stored procedure? : Sql server database administration
What is the xml datatype?
Can you type more than one query in the query editor screen at the same time?
How to rebuild all indexes on a single table?