ETL job items, job groups, and job schedulers

ETL job items define an ETL transformation script or rebuild hierarchy process that is used to capture information from the TRIRIGA® database, transform it, and load it into fact tables. ETL job groups are simply collections of ETL job items. Job schedulers define when ETL job items and job groups are to run. A job schedule must be activated to run the jobs that are associated with it.

The TRIRIGA Workplace Performance Management analytic/reporting tool calculates metrics that are used to generate reports and graphs by using queries against fact tables that are grouped by the data in flat hierarchy tables. ETL job items are used by the Job Scheduler to trigger the workflows that extract data from source tables, such as TRIRIGA business object tables, and loading it into fact tables. ETL job items also can be used to update flat hierarchies.