Interested to Buy Any Domain ? << Click Here >> for more details...
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
How many types of cursor type are there?
How to check if a table is being used in sql server?
What is open database communication (odbc)?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is difference between createstatement and preparedstatement?
What is bcp? When does it use?
How to view existing indexes on an given table using sp_help?
Can select statements be used on views in ms sql server?
Why use view instead of a table?
How can I track the changes or identify the latest insert-update-delete from a table?
How can we use ConnectorJ JDBC Driver with MS SQL?
How many databases Microsoft SQL server provides?
What do you understand by mirroring and mention the advantages of the mirroring?
How many types of functions are there in sql server?
What are the basic features of a trigger in ms sql server?
