1Z0-591 · Question #28
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…
The correct answer is B. By creating a bridge table that represents one employee doing one job, with several rows for an. 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…
Question
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?
Options
- ABy modeling the many to many relationship in the business model
- BBy creating a bridge table that represents one employee doing one job, with several rows for an
- CBy creating the many to many join in the physical model
- DBy creating a logical table source (LTS) that joins the Employees and Jobs tables
How the community answered
(49 responses)- A12% (6)
- B78% (38)
- C4% (2)
- D6% (3)
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.
Topics
Community Discussion
No community discussion yet for this question.