Explain the different between Operation Data store, InfoCube and Multi

1.	Explain the different between Operation Data store, InfoCube and MultiProvider?
Answer» ODS − They provide granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI. InfoCube − This is used for star schema, we can only append data, ideal for primary reporting. MultiProvider − It contains a physical data and allow to access data from different InfoProviders.

Explain the different between Operation Data store, InfoCube and MultiProvider?

Answer»

ODS −

They provide granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI.

InfoCube −

This is used for star schema, we can only append data, ideal for primary reporting.

MultiProvider −

It contains a physical data and allow to access data from different InfoProviders.