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 encryption key?
How secure is sql server database?
Does partitioning help performance?
Can we perform backup restore operation on tempdb?
Explain an incremental backup?
Do you know sql server 2008 backup compression?
What is tempdb database? : SQL Server Architecture
What is update_statistics command?
What is a DBMS, query, SQL?
Is sql server free?
What are the dmvs? : sql server database administration
What are the advantages of paper records?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the purpose of sql profiler in sql server?
What is the difference between sdf and mdf?
