大会员任务流程和insert表说明
2022-04-14 10:44:56 3 举报
大会员任务流程和insert表说明
作者其他创作
大纲/内容
hv_e2_dim_d01_member_information_dhy_c5 C5会员表bu:C5
hv_app_a01_customer_consume_dhy_gc 消费交易+会员量最终结果表:锁板数据+轧差结果 data_part:hlz hlz_day
insertdim.d01_longzhu_customer_flag花珑珠会员数统计表
insertapp.a01_customer_consume_dhy_hyxf_prefix客户消费表------前置任务数据
hv_app_a03_t_big_member_data_source 珑珠宝数据源
insert app.a03_longzhu_member_bsc_score_dhy_jk珑珠大会员得分数据源表
hv_app_a01_customer_consume_lockver_download下载表任务
insertapp.a01_customer_consume_offset会员数轧差表
DWD_DIM.dim_d01_project_grade2022会员数与花珑珠会员数的分档目标值表
insertapp.a01_customer_consume_dhy会员交易+会员数量 统计表
hv_app_a01_customer_consume_dhy_hyxf_fenmuC1C2C3消费数据分母data_part:fenmu
insertapp.a01_member_dhy 会员数量统计表 全量 天粒度
hv_app_a01_longzhu_member_bsc_score_daytotal_hlz 花珑珠会员数 按天统计任务 每年统计一次花 珑珠的会员data_part:hlz
hv_app_a03_longzhu_member_bsc_score_dhy_jk 珑珠大会员得分接口
hv_app_a01_user_transaction_longzhu珑珠交易任务
hv_e2_d01_longzhu_customer_flag 花珑珠会员数
insertdim.d01_member_information_dhy大会员会员表 会员信息维度表【会员明细信息表,不包含已注销会员】 全量 天粒度
hv_app_a01_customer_consume_dhy_hyxf_fenmu_fenzi_c5C5消费数据data_part:fenmu_fenzi_c5
hv_app_a01_customer_consume_dhy_hyxf_hysr_c2C2消费数据data_part:hysr_c2
hv_app_a01_longzhu_member_bsc_score_daytotal_dhy 消费交易额+会员数 按天统计任务 data_part:dhy
insertapp.a01_customer_consume_1_tmp C1-C4会员交易收入明细表
hv_e2_d01_longzhu_member_bsc_rule 分档指标表
hv_app_a01_customer_consume_dhy_hysl 会员数量 月
hv_app_a01_customer_consume_offset会员数量轧差任务:计算未锁板数-锁板数 大会员数量轧差表
hv_app_a01_longzhu_member_index_unlock[锁板]'lock' as index_version
hv_app_a01_customer_consume_01 C1-C3会员交易收入明细表
hv_app_a01_customer_consume_lockver 客户消费表+会员数量_锁版
insertapp.a03_longzhu_member_bsc_score_dhy珑珠大会员得分数据源表
hv_app_a01_user_transaction_longzhu_lock珑珠交易锁板任务
hv_app_a01_longzhu_member_new_soucre 珑珠宝数据源
hv_app_a03_longzhu_member_bsc_score_dhy 大会员得分
insertapp.a01_longzhu_member_bsc_score珑珠大会员bsc得分表
hv_app_a01_longzhu_member_lock[不锁板] 'unlock' as index_version
hv_e2_dim_d01_member_information_dhy_c2 C2会员表bu:C2
insertapp.a01_customer_consume_lockver客户消费表+会员数量_锁版
hv_app_a01_customer_consume_dhy_hyxf_hysr_c1C1消费数据data_part:hysr_c1
hv_app_a01_customer_consume_dhy_hyxf_hysr_c3C3消费数据data_part:hysr_c3
hv_app_a01_longzhu_member_year_history_dhy 花珑珠会员数量 锁板任务
insertdim.d01_longzhu_member_bsc_rule分档目标值
hv_app_a01_longzhu_member_bsc_score_hlzhysbs得分(花珑珠会员倍数)
DWD_DIM.dim_raqsoft_d01_level_grade会员成交金额占比的分档目标值表
insertapp.a01_longzhu_member_index得分计算用基础指标表[项目粒度基础指标表]
insert app.a01_user_transaction_longzhu 珑珠交易表
insertapp.a03_t_big_member_data_source珑珠宝数据源表
insertapp.a01_longzhu_member_year_history花珑珠会员数量历史数据
insertapp.a01_customer_consume_hyxf_offset客户消费轧差表
insertapp.a03_t_big_member_data_source_jk珑珠宝数据源表(看板接口)
insertapp.a01_customer_consume_dhy_gc客户消费表+会员数量_轧差
hv_app_a01_customer_consume_dhy_hyxf_jiacheng计算加成金额data_part:jiacheng
hv_app_a01_customer_consume_dhy_hysl_day 会员数量 天
insertapp.a01_longzhu_member_bsc_score_daytotal天粒度 花珑珠数+消费交易+会员数 统计结果表
hv_e2_dim_d01_member_information_dhy_c3 C3会员表bu:C3
hv_app_a03_t_big_member_data_source_jk 珑珠宝数据源
hv_app_a01_customer_consume_02 C4会员交易收入明细表
hv_app_a01_customer_consume_hyxf_offset消费交易金额轧差任务:计算未锁板数-锁板数大会员会员消费轧差表
hv_app_a01_member_dhy会员数量统计任务
hv_app_a01_customer_consume_dhy_hyxf_done 会员消费统计任务(总额、交易总额、加成金额)
hv_app_a01_customer_consume_dhy_hyxf_fenmu_fenzi_c4C4消费数据data_part:fenmu_fenzi_c4
hv_e2_dim_d01_member_information_dhy_c1 C1会员表bu:C1
hv_e2_dim_d01_member_information_dhy_c4 C4会员表bu:C4
insert app.a01_user_transaction_longzhu_lock 珑珠交易锁板表
insertapp.a01_longzhu_member_new_soucre珑珠宝数据源
收藏
0 条评论
下一页