Page tree


Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Required to access solvay-ind-conso-[env]

Source

  •      ftp.credit360.com    → GCP solvay-ind-conso-[env]
  • Loading by plan PL_EHS_PURE_HOURLY : At 08:00 CET, on day 1, 5, 10, 15, 20, 25, and 30 of the month on project WS_EHS_PURE

Format

  • Tablecolumnar format (file .dsv)

Destination

...

Product

  • Bucket = cs-ew1-prj-data-industrial-dash-dev-staging
  • DataOean GCP = prj-data-industrial-dash-[env]
  • DM 
    • FACT_trii_site
    • FACT_trii_gbu
    • FACT_pse_site
    • FACT_pse_gbu

...

1.2 Full load

Plan PL_TRII_PSE run run 9:00 AM on date  1,5,10,15,20,25,30.  There is no context variable to reload

  • F080_FACT_trii_site
  • F081_FACT_trii_gbu
  • F082_FACT_pse_site
  • F083_FACT_pse_gbu

1.3. Reloading data

Just do the full load again

1.4 Plan to schedule

WS_EHS_PURE: PL_EHS_PURE_HOURLY : At 08:00 CET, on day 1, 5, 10, 15, 20, 25, and 30

WS_IND_DASHBOARD: PL_TRII_PSE run 9:00 AM on date  1,5,10,15,20,25,30

...