Star or Snowflake

[#1]

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

[#2]

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

[munna1317]

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