1072: l_reverse varchar2(100);
1073: BEGIN
1074: l_denorm_table := 'BSC_DN_';
1075: select reverse(p_dim_short_name) into l_reverse from dual;
1076: l_denorm_table := l_denorm_table|| bsc_aw_utility.get_hash_value(p_dim_short_name,100,1073741824)||'_'||
1077: bsc_aw_utility.get_hash_value('*'||l_reverse,100,1073741824);
1078: return l_denorm_table;
1079: END;
1080:
1073: BEGIN
1074: l_denorm_table := 'BSC_DN_';
1075: select reverse(p_dim_short_name) into l_reverse from dual;
1076: l_denorm_table := l_denorm_table|| bsc_aw_utility.get_hash_value(p_dim_short_name,100,1073741824)||'_'||
1077: bsc_aw_utility.get_hash_value('*'||l_reverse,100,1073741824);
1078: return l_denorm_table;
1079: END;
1080:
1081: