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 fact table and its dimension tables formed?

April 26, 2017dimension fact formed relationship Table tables

0

Posted

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

1 Answer

0

Posted

The fact table contains all key fields of the associated dimension tables in its table definition. Note the following naming convention here: The key fields of the dimension tables in the fact table begin with the ‘KEY_’ prefix followed by the short form of the name of the fact table, and end with an identifier for the dimension. For example, the ‘P’ indicator means package dimension, ‘T’ is the time dimension, ‘U’ is the unit dimension, or a sequential number may be used to specify other dimensions. For example: The following dimension tables have been assigned to the /BIC/FZBCS_BC01 fact table: /BIC/DZBCS_BC01P, /BIC/DZBCS_BC01T, /BIC/DZBCS_BC0U, /BIC/DZBCS_BC011, /BIC/DZBCS_BC012, /BIC/DZBCS_BC013, /BIC/DZBCS_BC015, /BIC/DZBCS_BC016, /BIC/DZBCS_BC017, /BIC/DZBCS_BC018. The column names are created as follows: KEY_ZBCS_BC01P: represents the reference to the package dimension using the DIMID lead column of the /BIC/DZBCS_BC01P package dimension. The same applies to the following colum