Informatica 的缓慢变化维 (Slowly Dimension)
作者:彭玉兴
MSN:j2eesky@live.cn
第一种方式:keep most recent values in target
第二种方式:keep a full history of changes in the target
第三种方式:keep the current and previous values in the target
针对第一种方式,我们做如下实验:
创建源表
-- Create table
create table SDIMENSION_EMPLOYEE
(
NAME VARCHAR2(30) not null,
SEX VARCHAR2(10),
ADDRESS VARCHAR2(100),
GRADE VARCHAR2(100)
)
tablespace PM_USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 512
next 512
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table SDIMENSION_EMPLOYEE
add constraint PK_NAME primary key (NAME)
using index
tablespace PM_USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 512K
next 512K
minextents 1
maxextents unlimited