What Is The Difference Between Infocube And Ods?

1.	What Is The Difference Between Infocube And Ods?
Answer» InfoCube is structured as per EXTENDED Star Schema with the fact table surrounded by different DIMENSION TABLES which connect to SIDs. And the data can be aggregated in the InfoCubes. ODS is a flat structure and does not use the star schema concept and has DETAILED data in transparent tables. InfoCube is structured as per Extended Star Schema with the fact table surrounded by different dimension tables which connect to SIDs. And the data can be aggregated in the InfoCubes. ODS is a flat structure and does not use the star schema concept and has detailed data in transparent tables.

Answer»

InfoCube is structured as per EXTENDED Star Schema with the fact table surrounded by different DIMENSION TABLES which connect to SIDs. And the data can be aggregated in the InfoCubes. ODS is a flat structure and does not use the star schema concept and has DETAILED data in transparent tables.

InfoCube is structured as per Extended Star Schema with the fact table surrounded by different dimension tables which connect to SIDs. And the data can be aggregated in the InfoCubes. ODS is a flat structure and does not use the star schema concept and has detailed data in transparent tables.

Discussion

No Comment Found

Related InterviewSolutions

Is It Necessary To Create The Partner Profiles In Case Of File To Idoc Scenario?
When To Report From R/3 And When From Bw?
When We Run Query At Run Time It Is Not Displaying One Key Figure Values What Could Be The Problem?
When We Run The Query At Query Run Time The Wrong Data Has Come For One Key Figure, What Might Be The Problem?
What Does The Term Cell Mean?
What Are Structures?
What Is Process Chain? How Many Types Are There? How Many We Use In Real Time Scenario?
What Is A Meta Chain?
What Is The Difference Between Value Fields And Key Figures In Co-pa?
What Is Operating Concern And Partitioning In Co-pa.