For the purposes of querying, cube loading, and creating
data marts and data warehouses, all four data storage structures (explained
in Overview of Common Data Sources)
can be optimized to improve performance. Some optimization can be achieved,
for example, by specifying transformation options in SAS Data Integration
Studio. Some optimization requires hardware configuration, as in the case
of SPD Engine tables. Cubes can be optimized for querying and loading during
the cube loading process. For SAS tables, database tables, and SPD Engine
tables, libraries can be defined in the metadata with options that enhance
performance.
For more information, see these
sections:
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.