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 stored by the master?
What are the types of table?
Explain primary key and foreign key constraints?
What is explicit mode in sql server?
What is a raid and what are different types of raid configurations?
What is scalar user-defined function?
What does null mean?
1 01 101 01010
What is primary key and example?
What are approximate numeric data types in ms sql server?
What is sql server 2000 work load governor?
Differentiate between ms sql server reporting services vs crystal reports?
What is the use of tempdb? What values does it hold?
What is the return type of executeupdate ()?
Why use update_statistics command in sql server?