STG & ODS

We always talk about STG and ODS in BI archi, so what is the role of these two phases in a BI archi?

- STG (Staging Area): is a set of tables that represent a true copy of the data source and are purged each time the ETL is run: it is a waiting area, a "boarding room" before the ODS phase; it is in these tables that we can find data in odd formats.

- ODS (Operating Data Store): is the place where the transformations, the crossings, ... etc; before feeding the datawarehouse and using as source the STG.

Read More STG & ODS