Operation Data Store or ODS means the CURRENT data that is required to do quick analysis or near realtime REPORTING.

On the other side Staging is a dump of all data that you gather form multiple and heterogeneous Sources, you cleanse this data, apply multiple business RULES, filter it and then push it to your Data Warehouse or ODS.

An ODS sits between your Staging/Factory and Data Warehouse. It gets a snapshot of most recent data, like if its a:

- Telecom provider it would store data of around 1 month to GIVE you quick and detailed analysis on multiple calls/sms's done on a daily basis.
- Bank would store data for 3-6 months to 1 year for your day today transactions. That's why if you require 1-2 years of transaction details it takes bank 1-2 days to provide you that list separately.
If both will not manage an ODS it will become very difficult to provide quick details to their customers, and it will be a very SLOW process and also an overhead on their servers also.

Operation Data Store or ODS means the current data that is required to do quick analysis or near realtime reporting.

On the other side Staging is a dump of all data that you gather form multiple and heterogeneous Sources, you cleanse this data, apply multiple business rules, filter it and then push it to your Data Warehouse or ODS.

An ODS sits between your Staging/Factory and Data Warehouse. It gets a snapshot of most recent data, like if its a:

- Telecom provider it would store data of around 1 month to give you quick and detailed analysis on multiple calls/sms's done on a daily basis.
- Bank would store data for 3-6 months to 1 year for your day today transactions. That's why if you require 1-2 years of transaction details it takes bank 1-2 days to provide you that list separately.
If both will not manage an ODS it will become very difficult to provide quick details to their customers, and it will be a very slow process and also an overhead on their servers also.