Data Target
###########

Rexpondo BI DWH project data source comes from the MySQL database rexpondo.

Transactional tables selected in this database to populate the **facts tables** into data warehouse are:

*   dynamic_field
*   dynamic_field_value
*   ticket_history
*   ticket_working

Tables selected in this database to populate the **dimensions tables** into data warehouse are:

*   article
*   article_data_mime
*   communication_channel
*   customer_company
*   customer_user
*   group_user
*   groups
*   queue
*   service
*   sla
*   ticket
*   ticket_history_type
*   ticket_lock_type
*   ticket_priority
*   ticket_state
*   ticket_state_type
*   ticket_type
*   users