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. 

  • Interview Candidate
  • 13
  • 4468

Showing Answers 1 - 13 of 13 Answers

nukaraj

  • Jul 26th, 2005
 

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

  Was this answer useful?  Yes

reddy074

  • May 28th, 2008
 

A Dimmensional modelling consists of 3 phases

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

  Was this answer useful?  Yes

cyberdiptikanta

  • Jun 26th, 2010
 

Star Schema is performance wise better than Snow Flake Schema.  As Star schema uses denormalise tables, so there will be less no of join as compared to Snow flake Schema.


Regards
Diptikanta

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions