Pages

Monday, 23 June 2014

What is Data warehousing ?

Data warehousing concepts (FAQ’s)
1)      What is Data warehouse?
Data warehouse is relational database used for query analysis and reporting. By definition data warehouse is Subject-oriented, Integrated, Non-volatile, Time variant.

Subject oriented     : Data warehouse is maintained particular subject.like HR,Sales,Loan ,etc.
Integrated               : Data collected from multiple sources integrated into a
                                   user readable unique format.
Non volatile             : Maintain Historical date.
Time variant            : data display the weekly, monthly, yearly.

No comments:

Post a Comment