· 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)
-
▼
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 Oracle?
- 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
-
▼
April
(21)
No comments:
Post a Comment