Data Warehousing Interview Question:

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?

Submitted by: Administrator

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
Submitted by: Administrator