# View: dt_genre_mappings

**View Name:** dt_genre_mappings
**Table Source:** `INTELLIGENCE.DBT_PROD.DT_GENRE_MAPPINGS`
**File Path:** `dt_genre_mappings.view.lkml`

## Overview

- **File Size:** 1594 bytes
- **Lines of Code:** 57
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: Select s.storename,
- mg.dms_master_genre,

## Dimensions

| Name | Type |
|------|------|
| `store` | string |
| `orchard_genre` | string |
| `orchard_sub_genre` | string |
| `store_genre` | string |
| `store_sub_genre` | string |

## Derived Table

```sql
#    sql: Select s.storename,
#og.genre,
#os.name,
#mg.dms_master_genre,
#msg.dms_master_subgenre
#from "ORCHARD_APP_REPORTING"."ART_RELATIONS"."GENRE" og
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."SUBGENRE" os on og.genre_id = os.genre_id
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."DMS_SUBGENRE_MAPPING" sgm on os.orchard_id = sgm.orchard_subgenre_id
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."DMS_MASTER_SUBGENRE" msg on msg.dms_master_subgenre_id = sgm.dms_master_subgenre_id
#join "ORCHARD_APP_REPORTING"."ART_RELATIONS"."DMS_MASTER_GENRE" mg on mg.dms_master_genre_id = msg.dms_master_genre_id
#join "FACTS"."PROD"."DIM_STORE" s on mg.customer_master_master_id = s.storeid ;;
#
```