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 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: