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

Interview Candidate
Jun 23rd, 2006
9
2806

Showing Answers 1 - 9 of 9 Answers

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