客户关系管理中的数据仓库应用
1. 表结构创建
在数据管理中，首先创建了两个基础表：
create table dim_subscription_status ( subscription_status_key int not null, subscription_status_code char(2), description varchar(50), source_system_code tinyint, create_timestamp datetime, update_timestamp datetime, constraint pk_dim_subscription_status primary key clustered (subscription_status_key) ); create table dim_channel ( channel_key int not null, name varchar(20), description varchar(50), start_date smalldatetime, end_date smalldatetime, status varchar(10), source_system_code tinyint no
