Operational Data Store vs Data WareHouse

This is used for tactical decision making while the DW supports strategic decision 

contains transaction data, at the lowest level of detail for the subject area

–subject-oriented, just like a DW

–integrated, just like a DW

–volatile (or updateable) , unlike a DW

•an ODS is like a transaction processing system

•information gets overwritten with updated data

•no history is maintained (other than audit trail) or operational history

–current, i.e., not time-variant, unlike a DW

•current data, up to a few years

•no history is maintained (other than audit trail) or operational history

Summary

In WareHouse historical data gets appended with new records. For instance, there are 500 records in Analysis-Table, when new process triggers with 50 records then total records in warehouse will be 550. But in case of ODS There will be only 50 records.