1.

How Many Different Schemas Or Dw Models Can Be Used In Siebel Analytics. I Know Only Star And Snow Flake And Any Other Model That Can Be Used?

Answer»

Integrated schema design is also USED to define an integrated schema design we have to define the following concepts

► Fact constellation
► Act less fact table
► Onformed dimension
A: A fact constellation is the process of joining two or more fact tables
B: A fact table with out any FACTS is KNOWN as fact less fact table
C:A dimension which is re useful and fixed is known as conformed dimensionA dimension, which is, shared with multiple fact tables known as conformed dimension.

Integrated schema design is also used to define an integrated schema design we have to define the following concepts

► Fact constellation
► Act less fact table
► Onformed dimension
A: A fact constellation is the process of joining two or more fact tables
B: A fact table with out any facts is known as fact less fact table
C:A dimension which is re useful and fixed is known as conformed dimensionA dimension, which is, shared with multiple fact tables known as conformed dimension.


Discussion

No Comment Found

Related InterviewSolutions