ODS :Having data with Datwarehouse that will be stand alone. No further transaction will take place for current data which is part of the data ware house. Current data will be change once you upload throgh ETL on schedule basis.
OLTP : Having data with on line system which connected to network and all update on transaction hppened in seconds. Every second data summrasied value will get changed.
Though Both ODS and OLTP has current data ODS may contain normalized or Denormalized data. OLTP contains only normalized data. ODS used for some of calculations and to get instant reports.OLTP used for only Transactional data.
ODS is an Operational Data System which contains the snapshot of currently loaded data for clerical day to day analysis and includes a little history 30-60 days of historical data in addition to the current data.
OLTP is Online Transaction Processing System which contains only the current data and keeps changing not suitable for analysis due to temporal inconsistency unlike ODS which contains consistent data.
1. ODS - It is a decision support system which contains snapshot of current data for day to day analysis. This may include little history data also OLTP - It is a trasaction system though it contains current data it keeps changing due to lot of transaction. This does not have history data
2. ODS - It is data integrated subject oriented time variant and non volatile enterprise wide data for analysis OLTP - It is just transactional to support particular business process. It is not data integrated on different business process across organization
3. ODS - Denormalized data may contain normalized data also OLTP - Highly Normalized to reduce data redunduncy
