ETL Load Sequence
This table provides answers to questions about ETL load sequence for the Campus Solutions Warehouse.
Question |
Answer |
---|---|
In what order must I run dimension and fact jobs to implement the different Campus Solution Warehouse data marts? |
The topic Using the PeopleSoft EPM Lineage Spreadsheets provides information about the ETL jobs that are delivered with the Campus Solutions Warehouse and links to the ETL lineage spreadsheet, which you can use like a reverse-engineering tool and identify the sequence of jobs to run for a specific data mart. |
What is the loading sequence for Campus Solutions Warehouse fact jobs? |
There are some aggregate facts in the Campus Solutions Warehouse that have a dependency on the other facts as lookup or source tables. For example, in Student Records, the Academic Plan Summary Fact is the source table for the Institution Summary Fact. The required loading sequence for each module is provided below. |
Admissions and Recruiting:
|
|
Student Financials - Financial Aid:
|
|
Student Financials - Student Financials:
|
|
Student Records:
|
|
CRM for Higher Education:
|
|
Institutional Research:
|
|
What aggregate and/or snapshot fact tables are delivered for Campus Solutions Warehouse? |
The Campus Solutions Warehouse provides these aggregate and snapshot tables:
For more information on these tables, please refer to the fact table documentation provided in the Understanding the Campus Solutions Warehouse topic. |