DIM_INDICATOR_VALUES Duplicate Issues Related To DEFD1539 And Possibly Other DEs (Doc ID 2810273.1)

Last updated on OCTOBER 04, 2021

Applies to:

Goal

DIM_INDICATOR_VALUES has unique records for below combination of columns:

select 'DIM_INDICATOR_VALUES' table_name, count dup_count from eone.DIM_INDICATOR_VALUES group by 'DIM_INDICATOR_VALUES',to_char(V_INDICATOR_VALUE_CODE), to_char(N_INDICATOR_TYPE), to_char(n_indicator_numeric_code) having count > 1;

However there are some DEs like DEFD1539, that join to this DIM solely filter on n_indicator_type . And  duplicates when excluding n_indicator_numeric_code from above query.

The DEFD1539 would be impacted as its dataset is using dim_indicator_values as below:

LEFT OUTER JOIN DIM_INDICATOR_VALUES A_DIM_RETAIL_WHOLESALE_INDI ON A_DIM_RETAIL_WHOLESALE_INDI.V_INDICATOR_VALUE_CODE = DIM_PRODUCT.F_RETAIL_WHOLESALE_IND AND A_DIM_RETAIL_WHOLESALE_INDI.N_INDICATOR_TYPE = 28
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.