Oracle Extract transform load (ETL) Question:
Download Job Interview Questions and Answers 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.
Download Oracle ETL Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are the various transformation available? | What is the difference between etl tool and olap tools? |