ETL (Extract, transform, load) Interview Question:

Explain What is ODS (operation data source)?

Submitted by: Administrator

ODS - Operational Data Store.

ODS Comes between staging area & Data Warehouse. The data is ODS will be at the low level of granularity.

Once data was poopulated in ODS aggregated data will be loaded into into EDW through ODS.

ODS: ODS is also a simalar small DWH which will help analyst to analysis the bussiness.It will have data for less number of days. generally it will be around 30-45 days. Like DWH here also we will primary keys will be genrated, error and reject handling will be done.
Submitted by: Administrator