Characteristics Features of Data.Warehouse

•      Time Variant

•      Non Volatile

•      Integrated DB

•      Subject Oriented DB

Time Variant

•      DW is a Time Variant db which supports the users in analyzing the business with different time periods

                                       

Non Volatile

•      DW is a Non Volatile DB

•      Once data entered into DW, it doesn’t reflects to the changes which takes place in Operational Source

Integrated DB

DW is an Integrated db which can store the data in an integrated and homogeneous format

System Oriented DB

•      DW is a System Oriented DB which supports the business needs of individual depts in the enterprise

E.g.  Sales, hr, Accounts, Loans etc