cancel
Showing results for 
Search instead for 
Did you mean: 

Transactional ODS

Former Member
0 Kudos

Hai Gurus...

In which version Transactional ODS was released ?

thanks

Shiva....

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks a lot MK for the Reply....

Wts the Use Of the Transactional ODS.... Its is Similar To Transactional infocube.? But in T infocube...we can overwrite.... thn y they have released Transactional ODS......?

Shiva....

Former Member
0 Kudos

Shiva, still there other features(of ODS) which you can have access to...yes,transactional ODS doesn't support change log & it stores data only in 1 version..also can be used for business planning...

Some info on when to use basic ODS & Infocube..this might help you while selecting transactional ODS..

The most important difference between ODS and BW is the existence of key fields in the ODS. In the ODS you can have up to 16 info objects as key fields. Any other info objects will either be added or overwritten! So if you have flat files and want to be able to upload them multiple times you should not load them directly into the info cube, otherwise you need to delete the old request before uploading a new one. There is the disadvantage that if you delete rows in the flat file the rows are not deleted in the ODS.

I also use ODS-Objects to upload control data for update or transfer routines. You can simply do a select on the ODS-Table /BIC/A<ODSName>00 to get the data.

-


ODS is used as an intermediate storage area of operational data for the data ware house . ODS contains high granular data . ODS are based on flat tables , resulting in simple modeling of ODS .

we can cleanse transform merge sort data to build staging tables that can later be used to populate INOFCUBE .

Thanks

-


An infocube is a multidimentionsl dat acontainer used as a basis for analysis and reporting processing. The infocube is a fact table and their associated dimension tables in a star schema. It looks like a fact table appears in the middle of the graphic, along with several surrounding dimension tables. The central fact is usually very large, measured in gigabytes. it is the table from which you retrieve the interesting data. the size of the dimension tables amounts to only 1 to 5 percent of hte size of the fact table. common dimensions are unit & time etc. There are different type of infocubes in BW, such as basic infocubes, remote infocubes etc.

An ODS is a flat data container used for reporting and data cleansing/quality assurance purpose. They are not based on star schema and are used primaily for detail reporting rather than for dimensional analyais.

-


An infocube has a fact table, which contains his facts (key figures) and a relation to dimension tables. This means that an infocube exists of more than one table. These tables all relate to each other. This is also called the star scheme, because the dimension tables all relate to the fact table, which is the central point. A dimension is for example the customer dimension, which contains all data that is important for the customer.

An ODS is a flat structure. It is just one table that contains all data.

Most of the time you use an ODS for line item data. Then you aggregate this data to an infocube.

Former Member
0 Kudos

3.5, I believe along with BW-BPS.