IT Resource Management (ITRM) aggregation tables are a collection of accumulated statistics that are organized as summary or simple as specified in aggregation transformations.
The ITRM aggregation transformation creates and updates the majority of all ITRM metadata objects and physical SAS tables and does so with each and every run of the Aggregation jobs that contain these transformations. As such, this document proposes a best practice of which the physical tables created by the aggregation transformation be backed up prior to running the aggregation job such that they are available for restoration to quickly recover from the failure of any run of an Aggregation transformation; thus avoiding a more time consuming restoration of an IT data mart. The document introduces a tool for backing up and restoring physical aggregation tables named the ITRM Backup And Restore Facility for Physical Aggregation Tables.
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
The rapid growth of AI technologies is driving an AI skills gap and demand for AI talent. Ready to grow your AI literacy? SAS offers free ways to get started for beginners, business leaders, and analytics professionals of all skill levels. Your future self will thank you.