BW

[naveen_inuganti2]

Hi....

what is the defference between tables and cubes?

Thank you,

Naveen Inuganti

Edited by: Naveen Inuganti on Jun 8, 2008 11:42 AM

Edited by: Naveen Inuganti on Jun 13, 2008 11:41 AM

[Former Member]

Hi Naveen,

Actually there is no difference between these two.

The only difference is in the way we store data.

Each infocube is a collection of various tables like Dimension tables, SID tables and Fact tables.

Whereas each database table is an independent table in itself.

Hope it helps.

Regards

Hemant Khemani

[naveen_inuganti2]

HI...

So can i compare Cube with pooled and clusturd tables.. more than Comparision with transparant tables...?

Thanks,

naveen.I

[Former Member]

Hi Naveen,

I don't think you can compare them.

Pooled/Cluster table physically store the data related to many other tables whereas Infocube contains links between those various tables. The data is actually stored in Fact tables, Dim tables and SID tables.

Regards

Hemant Khemani