ETL (Extract, transform, load) Question:
Download Questions PDF

Explain 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: 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.

Download Extract, transform, load (ETL) Interview Questions And Answers PDF

Previous QuestionNext Question
Explain if a flat file cotains 1000 records how can i get first and last records only?How to use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?