How can the many to-many relationship issue be resolved?

An organization has its employees’ names in an Employees table, and information about their jobs
in a Jobs table.
However, an organization’s employees can have multiple jobs, and the same job can be
performed by multiple employees. This situation would result in a many to-many relationship
between the Employees and Jobs tables. How can the many to-many relationship issue be
resolved?

A.
By modeling the many to many relationship in the business model

B.
By creating a bridge table that represents one employee doing one job, with several rows for an
employee who has several jobs

C.
By creating the many to many join in the physical model

D.
By creating a logical table source (LTS) that joins the Employees and Jobs tables

Explanation:
When you need to model many-to-many relationships between dimension tables

and fact tables, you can create a bridge table that resides between the fact and the dimension
tables. A bridge table stores multiple records corresponding to that dimension. In the
Administration Tool, General tab in the Logical Table dialog box contains a check box that you can
select to specify that a table is a bridge table.
A bridge table allows you to resolve many-to-many data relationships.
Reference; OBI Server Administration Server Guide, Version 10.1, Identifying Bridge Tables