...
https://tufts.box.com/s/loj4qspzabjy9d37j6lse0hh2ckehfhm
/dia
Denodo Elements
The following is a list of all elements that were added in Denodo. The naming “_final” was used to denote views that serve as the final table, comparable to the original target table. The naming “_lineout” was used to denote views that serve as the lineout/csv file from the existing ETL. These views would be what an API can grab directly from.
...
fis2x_hr_url_all_sql
fis2x_hr_url_master_all_empids
fis2x_hr_url_master_all_emplids_plus_historical - **Cached
fis2x_hr_url_master_final
fis2x_hr_url_master_sql
p_bv_fis2x_hr_url_master
p_bv_fis2x_hr_url_master_tag
p_fis2x_hr_url_master_historical_query
...
Denodo Cache:
Two Denodo views in the overall workflow are cached as indicated above. Those cached views are refreshed in totality every day at 1 am via the Denodo Scheduler fis_hr_cache job. That job consists of two extract and load processes as shown below:
fis2x_hr0_001_final
...
fis2x_hr_url_master_all_emplids_plus_historical
...
Supporting Documents
FIS2X Elements documentation: https://tufts.box.com/s/juhfn9y3ua0oh1wxxqxpvlaxdvnptoap
...