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??

lakshmi

• Apr 30th, 2007

 

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

uma

• May 17th, 2007

 

there are 3 types of schemas
star schema
snowflake schema
and galaxy schema


by
uma

tisha24

 Profile Answers by tisha24 

• Dec 18th, 2008

 

one more is there, known as "GALAXY SCHEMA"