CCU ETL脚本列表

CCU执行流程

1. 7：30 执行 /opt/yanguang/etl/orads/kpi/kpi_auto_data.sh 需要追加游戏请修改配置文件kpi_ccu_site_cd.cfg
2. kpi_auto_data.sh产生kpi_imp_data.sh，kpi_imp_data.sh再调用kpi_ccu_his.sh
3. kpi_ccu_his.sh调用存储KPI.PROC_UPDATE_KPI_RPT_CCU

#!binbash
#auth maoyu
#date 
#desc kpi ccu data import
 
cur_dt$
  z $cur_dt 

  cur_dt` Ymd`
fi
 
cat kpi_ccu_site_cdcfg |awk $cur_dt$cur_dt$cur_dt$cur_dt  optyanguangetloradskpikpi_imp_datash
# binbash optyanguangetloradskpikpi_imp_datash
 


binbash optyanguangetloradskpikpi_ccu_hissh  optpass9kpisunkpi optpass9kpisunkpi orads dstage gamenow sun_ccu_his_20100222txt sun
binbash optyanguangetloradskpikpi_ccu_hissh  optpass9kpigekpi optpass9kpigekpi orads dstage gamenow ge_ccu_his_20100222txt ge
binbash optyanguangetloradskpikpi_ccu_hissh  optpass9kpififakpikpi optpass9kpififakpikpi orads dstage gamenow fifa_ccu_his_20100222txt fifa
binbash optyanguangetloradskpikpi_ccu_hissh  optpass9kpiwofkpikpi optpass9kpiwofkpikpi orads dstage gamenow mjsg_ccu_his_20100222txt mjsg
binbash optyanguangetloradskpikpi_ccu_hissh  optpass9kpiatkpi optpass9kpiatkpi orads dstage gamenow at_ccu_his_20100222txt 
binbash optyanguangetloradskpikpi_ccu_hissh  optpass9kpi9zkpikpi optpass9kpi9zkpikpi orads dstage gamenow 9war_ccu_his_20100222txt 9z
 


#!usrbinbash
#auth maoyu
#date 
#desc import ccu_his
source optyanguangcommonora_env_varsh
echo   optyanguangetloradskpiimpLOG
#current 
cur_dt$
  z $cur_dt 

  cur_dt` Ymd`
fi
 
#dest PATH 
work_path$
dest_path$
cd $dest_path
 
#set variable
# oracle USER password
db_server$ # 
ora_user$ # 
ora_pwd$ # 
 
# file name
init_file_name$
src_file_name
ctl_file_name1
des_file_name1
 
# site_cd
site_cd$
 
  f $src_file_name  
#build sqlldr ctl file
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
echo   $ctl_file_name1
 
#load_data  temporey 
sqlldr $ora_user$ora_pwd control$ctl_file_name1 bad$des_file_name1bad LOG$des_file_name1LOG rows skip
 
#process LOG 
echo   optyanguangetloradskpiimpLOG
 
sqlplus S $ora_user$ora_pwd  optyanguangetloradskpiimpLOG  EOF
   serveroutput  
  
    vcnt   
  
     COUNT 
     vcnt
     temp_kpi_ccu_daily_his
     site_cd  
       create_ts  TO_DATE     
       create_ts  TO_DATE   
 
     vcnt   
                  kpiproc_update_kpi_rpt_ccu TO_DATE   
        put_lineTO_CHARSYSDATE   
 
     
      put_lineTO_CHARSYSDATE    
      
 
  
      
      put_lineTO_CHARSYSDATE    
  


EOF

  echo   optyanguangetloradskpiimpLOG
fi

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25618347/viewspace-713877/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25618347/viewspace-713877/