prompt PL/SQL Developer import file
prompt Created on 2013年9月9日 by Administrator
set feedback off
set define off
prompt Creating DIM_PRODUCTS...
create table DIM_PRODUCTS
(
PROD_KEY NUMBER,
PROD_DSC VARCHAR2(255 CHAR),
TYPE_KEY NUMBER,
TYPE VARCHAR2(255 CHAR),
BRAND_KEY NUMBER,
BRAND VARCHAR2(255 CHAR)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
prompt Creating DIM_TIME_DAY...
create table DIM_TIME_DAY
(
CAL_DATE DATE,
DAY_KEY NUMBER,
CAL_MONTH NUMBER,
PER_NAME_MONTH VARCHAR2(255 CHAR),
CAL_YEAR NUMBER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
prompt Creating FACT_REVENUE...
create table FACT_REVENUE
(
SHIPTO_ADDR_KEY NUMBER,
OFFICE_KEY NUMBER,
EMPL_KEY NUMBER,
PROD_KEY NUMBER,
ORDER_NUMBER NUMBER,
REVENUE NUMBER,
UNITS NUMBER,
DISCNT_VALUE NUMBER,
BILL_MTH_KEY NUMBER,
BILL_QTR_KEY NUMBER,
BILL_DAY_DT DATE,
ORDER_DAY_DT DATE,
PAID_DAY_DT DATE,
DISCNT_RATE NUMBER,
ORDER_STATUS VARCHAR2(20),
CURRENCY VARCHAR2(3),
ORDER_TYPE VARCHAR2(20),
CUST_KEY NUMBER,
SHIP_DAY_DT DATE,
COST_FIXED NUMBER,
COST_VARIABLE NUMBER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
prompt Disabling triggers for DIM_PRODUCTS...
alter table DIM_PRODUCTS disable all triggers;
prompt Disabling triggers for DIM_TIME_DAY...
alter table DIM_TIME_DAY disable all triggers;
prompt Disabling triggers for FACT_REVENUE...
alter table FACT_REVENUE disable all triggers;
prompt Deleting FACT_REVENUE...
delete from FACT_REVENUE;
commit;
prompt Deleting DIM_TIME_DAY...
delete from DIM_TIME_DAY;
commit;
prompt Deleting DIM_PRODUCTS...
delete from DIM_PRODUCTS;
commit;
prompt Loading DIM_PRODUCTS...
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (6, 'PocketFun ES', 106, 'Portable', 10002, 'FunPod');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (14, 'Install', 110, 'Install', 10003, 'HomeView');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (17, 'CompCell RX3', 101, 'Cell Phones', 10001, 'BizTech');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (19, 'LCD 36X Standard', 109, 'LCD', 10003, 'HomeView');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (8, 'V5x Flip Phone', 101, 'Cell Phones', 10001, 'BizTech');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (4, 'MPEG4 Camcorder', 105, 'Camera', 10002, 'FunPod');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (11, 'Plasma HD Television', 108, 'Plasma', 10003, 'HomeView');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (20, 'Bluetooth Adaptor', 104, 'Accessories', 10001, 'BizTech');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (12, 'LCD HD Television', 109, 'LCD', 10003, 'HomeView');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (16, 'MaxiFun 2000', 106, 'Portable', 10002, 'FunPod');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (1, 'MP3 Speakers System', 104, 'Accessories', 10001, 'BizTech');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (2, 'SoundX Nano 4Gb', 103, 'Audio', 10001, 'BizTech');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (3, 'MicroPod 60Gb', 103, 'Audio', 10001, 'BizTech');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (18, 'Tungsten E Plasma TV', 108, 'Plasma', 10003, 'HomeView');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (7, '7 Megapixel Digital Camera', 105, 'Camera', 10002, 'FunPod');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (5, 'Game Station', 107, 'Fixed', 10002, 'FunPod');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (13, 'Maintenance', 111, 'Maintenance', 10003, 'HomeView');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (15, 'HomeCoach 2000', 107, 'Fixed', 10002, 'FunPod');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (9, 'Touch-Screen T5', 102, 'Smart Phones', 10001, 'BizTech');
insert into DIM_PRODUCTS (PROD_KEY, PROD_DSC, TYPE_KEY, TYPE, BRAND_KEY, BRAND)
values (10, 'KeyMax S-Phone', 102, 'Smart Phones', 10001, 'BizTech');
commit;
prompt 20 records loaded
prompt Loading DIM_TIME_DAY...
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('28-03-2007', 'dd-mm-yyyy'), 20070328, 3, '2007 / 03', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('29-03-2007', 'dd-mm-yyyy'), 20070329, 3, '2007 / 03', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('30-03-2007', 'dd-mm-yyyy'), 20070330, 3, '2007 / 03', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('31-03-2007', 'dd-mm-yyyy'), 20070331, 3, '2007 / 03', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('01-04-2007', 'dd-mm-yyyy'), 20070401, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('02-04-2007', 'dd-mm-yyyy'), 20070402, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('03-04-2007', 'dd-mm-yyyy'), 20070403, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('04-04-2007', 'dd-mm-yyyy'), 20070404, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('05-04-2007', 'dd-mm-yyyy'), 20070405, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('06-04-2007', 'dd-mm-yyyy'), 20070406, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('07-04-2007', 'dd-mm-yyyy'), 20070407, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('08-04-2007', 'dd-mm-yyyy'), 20070408, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('09-04-2007', 'dd-mm-yyyy'), 20070409, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('10-04-2007', 'dd-mm-yyyy'), 20070410, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('11-04-2007', 'dd-mm-yyyy'), 20070411, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('12-04-2007', 'dd-mm-yyyy'), 20070412, 4, '2007 / 04', 2007);
insert into DIM_TIME_DAY (CAL_DATE, DAY_KEY, CAL_MONTH, PER_NAME_MONTH, CAL_YEAR)
values (to_date('13-04-2007', 'dd-mm-yyyy'), 20070413, 4, '2007 / 04', 2007);
insert into D
BIEE入门教程数据脚本.zip
版权申诉
90 浏览量
2022-07-06
07:22:47
上传
评论
收藏 906KB ZIP 举报
BryanDing
- 粉丝: 297
- 资源: 5587