create table FACT_TAB
(
DATA VARCHAR2(33) not null,
A VARCHAR2(33),
B VARCHAR2(33),
C VARCHAR2(33)
);
create table DIM_TAB
(
DATA VARCHAR2(33) not null,
TARGET VARCHAR2(33),
TARGET_VALUE VARCHAR2(33)
);
insert into dim_tab
select DATA,'A' TARGET, A TARGET_VALUE FROM fact_tab UNION ALL
select DATA,'B' TARGET, B TARGET_VALUE FROM fact_tab UNION ALL
select DATA,'C' TARGET, C TARGET_VALUE FROM fact_tab ;
-- 行列转换