Answer Detail: RE: Dimensional modelling is again sub divided into 2 types.

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Print |

Question: Dimensional modelling is again sub divided into 2 types.

Answer:
a)Star Schema - Simple & Much Faster. Denormalized form.
b)Snowflake Schema - Complex with more Granularity. More normalized form.

October 10, 2008 08:09:59	#4
shady2pac	Member Since: September 2008 Total Comments: 1
RE: Dimensional modelling is again sub divided into 2 types.
Is not star schema better performance wise (querying) as it has less no of join due to denormalized structure? Please clarify

Back To Question