volte.yml 855 B

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. VERSION: 1.0.0.1
  2. DATABASE: sqmmt
  3. USER: gpadmin
  4. HOST: 192.168.70.109
  5. PORT: 5432
  6. GPLOAD:
  7. INPUT:
  8. - SOURCE:
  9. LOCAL_HOSTNAME:
  10. - 192.168.10.9
  11. PORT: 54321
  12. FILE:
  13. - /data/terminal/distinct/volte_terminal_20220509.csv
  14. - FORMAT: csv
  15. - DELIMITER: '|'
  16. - HEADER: false
  17. - ENCODING: utf-8
  18. - ERROR_LIMIT: 20000000
  19. - LOG_ERRORS: true
  20. EXTERNAL:
  21. - SCHEMA: tas_master
  22. OUTPUT:
  23. - TABLE: tas_master.o_info_list_volte_terminal
  24. - MODE: merge
  25. - MATCH_COLUMNS:
  26. - msisdn
  27. - UPDATE_COLUMNS:
  28. - imsi
  29. - imei
  30. - tac
  31. - fact_name
  32. - terminal_name
  33. - hprovince
  34. - hprovince_name
  35. - hcity
  36. - hcity_name
  37. - vprovince
  38. - vprovince_name
  39. - vcity
  40. - vcity_name
  41. - is_volte
  42. - day_date