SAS Data Integration Studio provides seven specific transformations
to load data. Although most data-related transformations load data
into temporary SAS WORK tables, these Loader Transformations are designed
to output to permanent, registered tables (that is, tables that are
available in the Folder or Inventory Tree). Loaders can create and
replace tables and maintain indexes, as do the other transformations.
Loaders can also do updates and appends, and they can be used to maintain
constraints.
SAS Data Integration
Studio provides the following transformations for loading data into
permanent output tables:
-
The SCD Type 1 and Type 2 Loader
transformations load source data into a dimension table, detect changes
between source and target rows, update change tracking columns, and
apply generated key values. These transformations implement slowly
changing dimensions. For more information, see
Transformations That Support Slowly Changing Dimensions.
-
The SPD Server Table
Loader transformation reads a source and writes to an SPD Server target.
This transformation is automatically added to a process flow when
an SPD Server table is specified as a source or as a target. It enables
you to specify options that are specific to SPD Server tables. For
more information, see
About the SPD Server Table Loader Transformation.
-
The Teradata Table Loader transformation
is specifically designed to optimally load Teradata tables. It provides
different load options depending on whether the source table is in
the same Teradata database as the target table. For more information,
see
Teradata Table Loader Transformation.
-
The Table Loader transformation is
a general loader that reads a source table and writes to a target
table. This transformation can be used to load SAS and most DBMS tables,
as well as Excel spreadsheets. The code generated by this transformation
includes syntax that is specific to the output data type. For more
information, see
About the Table Loader Transformation.
-
-
The DB2 Bulk Table Loader
transformation can be used to bulk load SAS and most DBMS source tables
to a DB2 target table. For more information,
see About the DB2 Bulk Table Loader.
All loader transformations
write to a table that is registered to a library. For more information
about registering tables and libraries, see the appropriate sections
in the "Connecting to Common Data Sources" chapter of the
SAS
Intelligence Platform: Data Administration Guide.