Running ETL transforms
Use the TRIRIGA® Job
Scheduler to run the ETL job items and job groups that are used to
move data into the TRIRIGA fact
tables or flattened hierarchy tables.
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.
Creating or modifying ETL job items
ETL job items define the scripts that capture information from the TRIRIGA database, transform it, and load it into fact tables or flattened hierarchy tables.
Adding or modifying job groups
To simplify job scheduling, use job groups to make collections of ETL job items to be run on the same schedule.
Creating or modifying job schedulers
Use job schedulers to schedule when TRIRIGA runs ETL job items and job groups. You can schedule jobs to run on an hourly, daily, weekly, or monthly basis.