...
Mainline was tasked with migrating TUFTS existing SAP HR extracts workflow into DENODO. The following documents important information related to this migration.
Diagram
TODO
Denodo Elements
The following is a list of all elements that were added in Denodo. The list shows folders bolded with all views inside them. 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.
DB - Education_technology
Location - 03-integration/SAP_Refactoring/
FIS2X_employees_plus:
df_fis2x_hr_pre_proc_step1
df_fis2x_hr_pre_proc_step2
u_j_fis2x_hr_pre_proc_step2
fis2x_employees_plus_final
...
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
TODO - add job name for nightly cache refresh
Supporting Documents
FIS2X Elements documentation: DI_JOB_FIS2X_Generate_Extracts.xlsx
...