BookmarkSubscribeRSS Feed


Started ‎11-30-2011 by
Modified ‎10-05-2015 by
Views 909

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.

Version history
Last update:
‎10-05-2015 02:56 PM
Updated by:


Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.


Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Tags