Why is the Data Mart database much larger than the Data Warehouse database? (NETIQKB50953)

  • 7750953
  • 02-Feb-2007
  • 09-Mar-2011


NetIQ Analysis Center 2.x


Why are the sizes of the DataMart and Data Warehouse significantly different?


The Analysis Center DataMart database is typically much larger than the AC_Warehouse database. The DataMart database stores the AppManager repository data and ArchiveData tables. When Analysis Center populates the OLAP cubes, the program accesses this data using linked servers.  The AC_Warehouse database does not directly contain the fact data.

Additional Information

Formerly known as NETIQKB50953