Q36画像宽表链路

建表olashare.dws_ola_prf_model_all_qimei36_d_ql用表olashare.dws_ola_prf_all_user_info_qimei36_d_ql和表olashare.dws_ola_prf_model_brand_model_qimei36_d_ql左关联

 建表olashare.dws_ola_prf_all_qimei36_d_ql用表olashare.dws_ola_prf_all_user_info_qimei36_d_ql和表olashare.dws_ola_prf_base_all_qimei36_d_ql和表olashare.dws_ola_prf_model_all_qimei36_d_ql和表olashare.dws_ola_prf_lbs_all_qimei36_d_ql和表olashare.dws_ola_user_all_q36_first_time_d_ql和表olashare.dws_ola_lbs_hometown_multi_source_merge_q36_m_last

建表olashare.dws_ola_prf_all_user_info_qimei36_d_ql用表olashare.dws_ola_user_all_qimei36_d_ql和几个表olashare.dws_ola_ids_map_qimei36_uid_d_ql左连接

建立表olashare.dws_ola_prf_all_encode_t1_qimei36_d_q用olashare.dws_ola_prf_all_qimei36_d_ql与表dw.t_rm_dm_mkg_code_last和表 olashare.dim_ola_prf_all_tag_value_code_last_d_ql左关联

建表olashare.dws_ola_prf_lbs_all_qimei36_d_ql用表olashare.dws_ola_prf_all_user_info_qimei36_d_ql和表olashare.dws_ola_prf_lbs_province_city_qimei36_d_ql和表olashare.dws_ola_prf_lbs_province_city_qimei36_30days_d_ql和表olashare.dws_ola_prf_lbs_province_city_qimei36_90days_d_ql和表olashare.dwd_ola_lbs_q36_home_work_place_m_last左关联

建表olashare.dws_ola_user_all_q36_first_time_d_ql

建立表olashare.dws_ola_prf_all_encode_qimei36_d_ql，用olashare.dws_ola_prf_all_encode_t1_qimei36_d_ql与表olashare.dws_ola_prf_all_qimei36_4renchang_d_zl左关联

建表olashare.dws_ola_prf_base_all_qimei36_d_ql用表olashare.dws_ola_prf_all_user_info_qimei36_d_ql和表 olashare.dws_ola_prf_base_gender_q36_find_d_ql和表olashare.dws_ola_prf_base_age_q36_find_d_ql和表olashare.dws_ola_prf_base_grade_qimei36_d_ql和表olashare.dws_ola_prf_base_college_q36_find_d_ql和表olashare.dws_ola_prf_base_constellation_q36_find_d_ql和表olashare.dws_ola_prf_base_lifestatus_q36_find_d_ql和表olashare.dws_ola_prf_base_gender_q36_find_d_ql和表olashare.dws_ola_prf_base_age_q36_find_d_ql和表olashare.dws_ola_ids_map_qimei36_uid_d_ql和表dw.t_am_dm_user_qq_profile_last和表olashare.dws_ola_prf_base_gender_q36_find_d_ql和表olashare.dws_ola_prf_base_age_q36_find_d_ql和表olashare.dws_ola_prf_base_industry_occupation_q36_a_ql和表olashare.dws_ola_diploma_q36_prf_final_mirror_ql和表olashare.dws_ola_college_student_q36_prf_final_mirror_ql和表olashare.dws_ola_lifestatus_q36_prf_final_mirror_ql  

把sz1_olashare.dws_ola_prf_all_encode_qimei36_d_ql数据同步到pcg_datashare_app.dws_ola_prf_all_encode_qimei36_d_ql