Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How is the relationship between the dimension table and its master data tables formed?

April 26, 2017Data dimension formed master relationship Table tables

0

Posted

How is the relationship between the dimension table and its master data tables formed?

1 Answer

0

Posted

The columns of the dimension table that form a relationship to the master data table are defined as key fields in the master data table. To ensure that the assignment of master data tables to the dimension table is immediately apparent for a performance analysis, the dimension table is sorted and stored in the FROM clause, followed by its master data tables. For example: SELECT …..FROM /BIC/FZBCS_BC01 ” “F” -> Fact table /BIC/DZBCS_BC01T ” “DT” , -> Dimension table /BI0/SFISCVARNT ” “S44″ , -> Master data table /BI0/SFISCYEAR ” “S45” , -> Master data table For example, the S44 master data table has the FISCVARNT column as a key field. The S45 master data table has the FISCVARNT and FISCYEAR columns as its keys (columns that are contained in the dimension table as SID_0, for example, SID_0FISCVARNT and SID_0FISCYEAR). The relationship of the tables to each other is defined in the JOIN condition of the query.