What is DataWarehousing?

What is DataWarehousing?

DataWarehousing is the basically mean that It is Subject-oriented, Its a 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.
> It is Time-variant, Its a meaning that the changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time.
> It is Non-volatile, Its a meaning that data in the database is never over-written or deleted, Only once committed, The data should be static, And read-only, But retained for future reporting.
> It is Integrated, Its meaning that the database contains data from most or all of an organization\'s operational applications, And that this data is made consistent.

Date:2010-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher