What Is Regular Type, No Relation Type, Fact Type, Referenced Type, M

1.	What Is Regular Type, No Relation Type, Fact Type, Referenced Type, Many-to-many Type With Example?
Answer» No relationship: The DIMENSION and measure group are not RELATED. Regular: The dimension table is joined directly to the fact table. Referenced: The dimension table is joined to an intermediate table, which in TURN,is joined to the fact table. Many to many:The dimension table is to an intermediate fact table,the intermediate fact table is joined , in turn, to an intermediate dimension table to which the fact table is joined. Data MINING:The target dimension is based on a mining model built from the source dimension. The source dimension must also be INCLUDED in the cube. Fact table: The dimension table is the fact table.

What Is Regular Type, No Relation Type, Fact Type, Referenced Type, Many-to-many Type With Example?

Answer»

No relationship: The DIMENSION and measure group are not RELATED.
Regular: The dimension table is joined directly to the fact table.
Referenced: The dimension table is joined to an intermediate table, which in TURN,is joined to the fact table.
Many to many:The dimension table is to an intermediate fact table,the intermediate fact table is joined , in turn, to an intermediate dimension table to which the fact table is joined.
Data MINING:The target dimension is based on a mining model built from the source dimension. The source dimension must also be INCLUDED in the cube.
Fact table: The dimension table is the fact table.