topic Re: Star or Snowflake in Archived Groups

Star or Snowflake

Tue, 22 Jul 2025 17:59:49 GMT

There is a fact table and few dimension tables. The developer combines all tables into a single table. What has the developer done with the schema?

1. Snow Flake to Normalize

2. Snow Flake to DE Normalize

3. Star to Normalize

4. Star to DE Normalize

Please give me the solution

Re: Star or Snowflake

Fri, 01 Aug 2014 09:34:12 GMT

Hi,

For sure, the developper is making a denormalize operation.

Nevertheless, it's neither a snow flake model nor a star model as at the end of the procces, it will be only one table.

Regards,

Benjamin Drouin

Re: Star or Snowflake

munna1317 — Mon, 11 Aug 2014 09:35:11 GMT

hi,

Actually , developer must choose the better i.e if he need performance wise he should prefer Star , or if need memory utilization he should prefer Snowflake

Regards ,

Harish