You want
to maintain an existing SPD server cluster by adding a table to a
cluster, generating a list of tables that are included in a cluster,
or removing a cluster definition.
Solution
You
can use the List Cluster Contents transformation or the Remove Cluster
transformation. These transformations are explained in the following
table.
SPD Server Transformations
Server
Tasks That Require This Server
Add a table to
a cluster
Perform the following
steps to use the Create or Add to a Cluster transformation:
Create an empty job.
Drop the Create or Add to a Cluster transformation
into the Job Editor window.
Replace the temporary output table with the clustered
table.
Drag the cursor from the output port of the Create
or Add to a Cluster transformation to the input port of the cluster
table.
Run the job.
Generate a list of tables in a
cluster
Perform the following steps to
use the List Cluster Contents transformation:
Create an empty job.
Drop the List Cluster Contents transformation into
the Job Editor window.
Drop the cluster table onto the Job Editor window.
Drag the cursor from the output port of the cluster
table to the input port of the List Cluster Contents transformation.
Run the job.
Note that you can also include the List Cluster
Contents transformation in an SPD server cluster job. This generates
a cluster list each time you create a cluster.
Remove a cluster definition
Perform the following steps to
use the Remove Cluster transformation:
Create an empty job.
Drop the Remove Cluster transformation into the Job
Editor window.
Drop the cluster table into the Job Editor window.
Drag the cursor from the output port of the cluster
table to the input port of the Remove Cluster transformation.
Run the job.
The cluster table is now removed
and the tables that were in the cluster are now available as individual
tables.