28: edw_metadata_refresh.refresh_metadata_tables(Errbuf ,retcode);
29:
30: -- First delete data from tables
31:
32: delete from edw_sec_dim_info_t;
33: delete from edw_sec_fact_info_t;
34: delete from edw_sec_lvl_info_t;
35: delete from edw_sec_itemset_info_t;
36:
36:
37:
38: -- Now populate tables from owb repository views
39:
40: insert into edw_sec_dim_info_t
41: (dim_id,
42: dim_name,
43: dim_long_name,
44: table_name,
176: (
177: select
178: dim.dim_id
179: from
180: edw_sec_dim_info_t dim
181: WHERE
182: edw.dim_short_name = dim.dim_name
183: )
184: ;