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
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.
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
Retrieving data ...