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