GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 2 of 390    Print  
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: 4 Last Update: October 21, 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   #1  
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   #2  
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 | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
May 28, 2008 12:37:54   #3  
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
October 19, 2008 08:09:59   #4  
shady2pac Member Since: September 2008   Contribution: 2    

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
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape