Explain the difference between InfoCube and ODS?

1.	Explain the difference between InfoCube and ODS?
Answer» Infocube is structured as star schema where a fact table is surrounded by different dim table that are linked with DIM'ids. ODS is a flat structure with no star schema concept and which will have granular data (detailed level). Overwrite functionality.

Answer»

Infocube is structured as star schema where a fact table is surrounded by different dim table that are linked with DIM'ids.

ODS is a flat structure with no star schema concept and which will have granular data (detailed level). Overwrite functionality.

Discussion