1.

Explain Data Warehousing In Sql Server?

Answer»
  • 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.



Discussion

No Comment Found