DataStage - Dimensional modelling is again sub divided into 2 types.

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 2 of 377

Dimensional modelling is again sub divided into 2 types.

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

Total Answers and Comments: 3

Last Update: May 28, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: madhava1238

1. star schema 2.snow-flake schema
star schema ia denormalisation process
snow flake schema is a normalisation process.

performance wise snow flake schema is better

Above answer was rated as good by the following members:
giridatastage

July 26, 2005 04:21:16

nukaraj

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

i want routine documents and userdefined code of the routine?
And real time senario in datastage

Is this answer useful? Yes | No

May 05, 2008 06:35:52

madhava1238

Member Since: May 2008 Contribution: 8

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

1. star schema 2.snow-flake schema
star schema ia denormalisation process
snow flake schema is a normalisation process.

performance wise snow flake schema is better

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 28, 2008 12:37:54

reddy074

Member Since: April 2008 Contribution: 1

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

A Dimmensional modelling consists of 3 phases

a. Conceptual Modelling
b. Logical Modelling
c. Physical Modelling

Is this answer useful? Yes | No

Go To Top