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.