Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the differences between ODS and Info Cube?

April 26, 2017CUBE differences info ODS

0

Posted

What are the differences between ODS and Info Cube?

1 Answer

0

Posted

ODS holds transactional level data. It’s just as a flat table. It’s not based on multidimensional model. ODS have three tables 1. Active Data table (A table containing the active data) 2. Change log Table (Contains the change history for delta updating from the ODS Object into other data targets, such as ODS Objects or InfoCubes for example.) 3. Activation Queue table (For saving ODS data records that are to be updated but that have not yet been activated. The data is deleted after the records have been activated) Whereas Cube holds aggregated data which is not as detailed as ODS. Cube is based on multidimensional model.