Hi,

This is a common question, asked anywhere.

While loading into the Datawarehouse we gather data(source) from different source systems and place it in a STAGING area - which is literally called as ODS (operational Data Store) and from there, using an ETL tool, and depends upon the business logic we load the datawarehouse, which has historical data.

Aggregate table is like a FACT table in a star schema and it requires a proper Modelling of data, that we cant find in the ODS part.

Thanks
Javid