1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
estimation_traffic_passagers:
load ANNEE, MOIS, TERMINAL_ESTIM, JOUR, CLASSHORAIRE, TRAFIC_ESTIMÉ, NUM_VOL, TRAFIC_HISTO, ANNEE & MOIS & JOUR as key1;
SQL SELECT ANNEE, MOIS, TERMINAL AS TERMINAL_ESTIM, substr(DATE_PASSAGE, 1, 2) AS JOUR, CLASSHORAIRE, TRAFIC_ESTIMÉ, substr(ID_VOL_REF, 9) as num_vol, TRAFIC_HISTO from Estimation_trafic_passager_v2;
taux_remplissage_histo:
load ANNEE, MOIS, JOUR, VOLNO, LIB_JOUR_TXT2, HEUREMVT_HISTO, NBPLACE_HISTO, NB_PLACE_OCCUP_HISTO, ANNEE & MOIS & JOUR & VOLNO as key2 ;
SQL SELECT to_char(ANNÉE_réel +1) AS ANNEE, MOIS, JOUR, VOLNO, LIB_JOUR_TXT as LIB_JOUR_TXT2, HEUREMVT as HEUREMVT_HISTO, NBPLACE AS NBPLACE_HISTO, NB_PLACE_OCCUP AS NB_PLACE_OCCUP_HISTO from Tx_remplissage_histo;
planning_vol_histo:
load NBPLACE, ANNEE, MOIS, JOUR, HEUREMVT, VOLNO, LIB_JOUR, TERMINAL_PLANNING, ANNEE & MOIS & JOUR & VOLNO as key3;
SQL SELECT NBPLACE, substr(DATEMVT, 7, 4) as ANNEE, substr(DATEMVT, 4, 2) as mois, substr(DATEMVT, 1, 2) as JOUR, HEUREMVT, substr(ID_VOL, 13) AS VOLNO, LIB_JOUR, TERMINAL AS TERMINAL_PLANNING from planning_vol_2017;
taux_remplissage_réel:
load ANNEE, MOIS, JOUR, VOLNO, NBPLACE2, NB_PLACE_OCCUP, ANNEE & MOIS & JOUR & VOLNO as key4;
SQL SELECT ANNÉE_réel AS ANNEE, MOIS, JOUR, VOLNO, NBPLACE as NBPLACE2, NB_PLACE_OCCUP from Tx_remplissage_histo;
table_link:
load distinct ANNEE, MOIS, JOUR, key1 from estimation_traffic_passagers;
table_link2:
noconcatenate load distinct ANNEE, MOIS, JOUR, VOLNO, key2 resident taux_remplissage_histo;
table_link3:
noconcatenate load distinct ANNEE, MOIS, JOUR, VOLNO, key3 resident planning_vol_histo;
table_link4:
noconcatenate load distinct ANNEE, MOIS, JOUR, VOLNO, key4 resident taux_remplissage_réel;
drop fields ANNEE, MOIS, JOUR from estimation_traffic_passagers;
drop fields ANNEE, MOIS, JOUR, VOLNO from taux_remplissage_histo;
drop fields ANNEE, MOIS, JOUR, VOLNO from planning_vol_histo;
drop fields ANNEE, MOIS, JOUR, VOLNO from taux_remplissage_réel; |
Partager