i have totsl 5 cr records in all fact and dimension tables?

[Anonymous]

hen I create star schema datamodel with above records and

par allay I created snow flake schema datamodel  also

which application will be big size ?

star schema datamodel or snowflake schema ?

whether number of rows will  be same in  both dashboards ?

is there any rows difference because of star schema datamodel and snow flake schema data model ?

[PradeepReddy]

Star Schema or Snow Flaxe schema?

[kaushiknsolanki]

Hi,

The data size doesn't depend only on the numbers of records, it also take numbers of column, plus it also takes into account the visualisation.

Now About the schema's, There wont be any change in the numbers of records unless you have done wrong joins of the tables.

Regards,

Kaushik Solanki