ETL - what is ODS (operation data source)

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 29 of 59

what is ODS (operation data source)

Total Answers and Comments: 7

Last Update: April 03, 2008 Asked by: kumar

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 02, 2005 04:00:23

rajesh

RE: what is ODS (operation data source)

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.

Is this answer useful? Yes | No

November 12, 2005 04:38:55

harinder

Member Since: November 2005 Contribution: 1

RE: what is ODS (operation data source)

ODS is the Operational Data Source which is also called transactional data ODS is the source of a warehouse. Data from ODs is staged, transformed and then moved to datawarehouse.

Is this answer useful? Yes | No

December 11, 2005 03:11:29

madhu

BW questions

1.why currency conversion written in update rules?why not transfer rules?

2.if i assume update data into data targets?what is the procedure?

3.what are restricted characters?

4.what are virtual kf?

5.what restricted kf?

6.what RRI,where you can configure?

7.In dim table you can add customer field and along with material fields?

8.process chains means what?when and where you used?

9.what is the difference between BW reporting and abap reporting?

10.any enchancements you have done?explain?

11.which info objects you added?tell me some info objects?

Is this answer useful? Yes | No

January 09, 2006 05:51:43

sithusithu

Member Since: December 2005 Contribution: 161

RE: what is ODS (operation data source)

Operation data source

An updatable set of integrated operational data used for enterprise- wide tactical decision making.Contains live data, not snapshots,and has minimal history retained

Cheers,

Sithu

Is this answer useful? Yes | No

February 18, 2007 14:21:44

RAMESHKUMARREDDY

RE: what is ODS (operation data source)

ods means Oparational data Source it is coming from the oltp systems and it take only current data

Is this answer useful? Yes | No

March 08, 2007 02:47:15

saurabh verma

RE: what is ODS (operation data source)

Operational Data Store (ODS): An ODS is an integrated database of operational data. Its sources include legacy systems and it contains current or near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data.
it is before staging

Is this answer useful? Yes | No

April 03, 2008 05:53:00

Kalpana gopinath

Member Since: January 2008 Contribution: 5

RE: what is ODS (operation data source)

ODS is nothing but operational data source. It contains most recent data .it contains around 30-60 days data It is placed in between source system and staging area.. reports can also be taken in ODS .

Is this answer useful? Yes | No

Go To Top