GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing
Go To First  |  Previous Question  |  Next Question 
 Data Warehousing  |  Question 18 of 98    Print  
How Many different schema's or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE. Any other model that can be used??

  
Total Answers and Comments: 3 Last Update: December 18, 2008     Asked by: Sivakalyan 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 30, 2007 02:45:25   #1  
lakshmi        

RE: How Many different schema's or DW Models can be us...
integrated schema design is also used to define an integrated schema design we have to define the following concepts
1)fact constellation
2)fact less fact table
3)conformed dimension
1: A fact constellation is the process of joining two or more fact tables
2: A fact table with out any facts is known as fact less fact table
3:A dimension which is re useful and fixed is known as conformed dimension
or
A dimension which is shared with multiple fact tables known as conformed dimension

 
Is this answer useful? Yes | No
May 17, 2007 12:44:11   #2  
uma        

RE: How Many different schema's or DW Models can be us...
there are 3 types of schemas
star schema
snowflake schema
and galaxy schema


by
uma

 
Is this answer useful? Yes | No
December 18, 2008 06:25:49   #3  
tisha24 Member Since: September 2008   Contribution: 10    

RE: How Many different schema's or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE. Any other model that can be used??
one more is there known as "GALAXY SCHEMA"
 
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