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 the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How many levels of sp nesting are possible?
Explain how to integrate the ssrs reports in application?
What is coalesce in sql server?
What is the importance of a recovery model?
How many tables can be joined in SQL Server?
What are the limitations in ssrs on sql server express edition?
How can I change procedure name in sql server?
What is a periodical index?
what is a live lock? : Sql server database administration
Explain what is dbcc?
How to rebuild master databse?
Explain system views?
What is difference between rownum and row_number?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
