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 best institute to Learn DotNET And SQL in chennai?
What is the importance of three tier architecture?
Explain magic tables in sql server?
What is transact-sql language?
Does an index slow down updates on indexed columns?
Difference between drill down and drill through report.
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What is cdc in sql server?
How to loop through returning rows?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How many categories of data types used by sql server?
Explain the architecture of ms sql reporting service?
What are the types of indexing?
Define union, union all, minus, intersect?
Explain filestream storage of sql server 2008?