Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF
What is ODS (operation data source)?
Answer:
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 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.
| Previous Question | Next Question |
| What are the various transformation available? | What is the difference between etl tool and olap tools? |