· Subject-oriented, meaning that the data in the database is organized so that all the data
elements relating to the same real-world event or object are linked together;
· Time-variant, meaning that the changes to the data in the database are tracked and recorded
so that reports can be produced showing changes over time;
· Non-volatile, meaning that data in the database is never over-written or deleted, once
committed, the data is static, read-only, but retained for future reporting;
· Integrated, meaning that the database contains data from most or all of an organization's
operational applications, and that this data is made consistent.
Friday, April 18, 2008
What is DataWarehousing?
Labels:
SQL Interview Questions
Subscribe to:
Post Comments (Atom)
Archives
-
▼
2008
(41)
-
►
May
(20)
- Which command using Query Analyzer will give you t...
- What is SQL server agent?
- Can a stored procedure call itself or recursive st...
- What is @@ERROR?
- What is Raiseerror?
- What is log shipping?
- What is the difference between a local and a globa...
- What command do we use to rename a db?
- What is sp_configure commands and set commands?
- What are the different types of replication? Expla...
- What are the OS services that the SQL Server insta...
- What are three SQL keywords used to change or set ...
- What does it mean to have quoted_identifier on? Wh...
- What is the STUFF function and how does it differ ...
- Using query analyzer, name 3 ways to get an accura...
- How to rebuild Master Database?
- What is the basic functions for master, msdb, mode...
- What are primary keys and foreign keys?
- What is data integrity? Explain constraints?
- What are the properties of the Relational tables?
-
▼
April
(21)
- What is De-normalization?
- How to get @@error and @@rowcount at the same time...
- What is Identity?
- What is a Scheduled Jobs or What is a Scheduled Ta...
- What is a table called, if it does not have neithe...
- What is BCP? When does it used?
- How do you load large data to the SQL server datab...
- Can we rewrite subqueries into simple select state...
- Can SQL Servers linked to other servers like Oracl...
- How to know which index a table is using?
- How to copy the tables, schema and views from one ...
- What is Self Join?
- What is Cross Join?
- Which virtual table does a trigger use?
- List few advantages of Stored Procedure.
- What is DataWarehousing?
- What is OLTP(OnLine Transaction Processing)?
- How do SQL server 2000 and XML linked? Can XML be ...
- OPENXML
- What is an execution plan? When would you use it? ...
- Global Temporary Tables
-
►
May
(20)






0 comments:
Post a Comment