The SAS Scalable Performance Data (SPD) Server enables
you to create dynamic cluster tables. A dynamic cluster table is two
or more SPD Server tables that are virtually concatenated into a single
entity, using metadata that is managed by the SPD Server. Dynamic
cluster tables can be used as the inputs or outputs in SAS Data Integration
Studio jobs.
Before
you can create a cluster table, the following prerequisites must be
satisfied:
-
Administrators must have installed,
started, and registered an SPD Server. The application server that
executes the cluster table job must be able to access the SPD Server.
For more information about SPD Servers, see the chapters about common
data sources in the
SAS Intelligence Platform: Data Administration
Guide.
-
An SPD Server library must be available.
For more information about SPD Server libraries, see the chapters
about common data sources in the
SAS Intelligence Platform:
Data Administration Guide.
-
All of the source tables that
are to be added to a cluster table have been registered in the SPD
Server library. All source tables must have the same column structure.
-
A cluster table has been registered
in the SPD Server library. The cluster table and all of its source
tables must have the same column structure. One way to ensure that
all of these tables have the same columns is to use the New Table
wizard to copy the metadata from a source table and save it as the
metadata for the cluster table. For details about using the New Table
wizard, see
Registering New Tables with the New Table Wizard.