Question

A star schema has what type of relationship from a dimension to the fact table? Select one: One-to-many Many-to-many Many-to-one One-to-one

Answer 1

The answer is A- one-to-many.

A start schema is the simplest form of data mart schema. It is used to develop data warehouses and dimensional data marts. A star schema has one or more fact tables, one set of dimension tables and joins that relate the fact tables to the dimension tables.

Answer 2

The answer is one-to-many.

A star schema has one-to-many type of relationship from a dimension to a fact table. One or more fact tables refer ‘n’ number of dimension tables. This can be represented diagrammatically in the shape of a star with a fact table at the center and dimension tables surrounding it and representing the different points of a star.