Question: why ods in data warehouse?
Answer: An operational data store (or "ODS") is used for operational reporting and as a source of data for the Enterprise Data Warehouse (EDW). ... An ODS is a database designed to integrate data from multiple sources for additional operations on the data, for reporting, controls and operational decision support.