SAS/Warehouse Administrator Metadata Types

WHCTRNFM

Metadata type for column transformations

Category:

Process Types

Parent
Overview
Properties
Using WHCTRNFM

Parent

WHROOT

Overview

WHCTRNFM models the metadata for column transformation processes in the SAS/Warehouse Administrator Process Editor. A column transformation is a data mapping process in which data from the source column is either mapped one-to-one to a target column or is transformed before it is loaded into the target column. The WHCTRNFM type corresponds to the one-to-one mappings or derived mappings that are defined on the Columns tab of the Mapping Process Properties window. The following is one way to add a derived mapping through the SAS/Warehouse Administrator interface:

In the Explorer, select a table with the right mouse button.
Select Process from the pop-up menu.
In the Process Editor, select the table with the right mouse button.
Select Add Inputs
Select an input source from the Input Selector window.
When the input source and the Mapping box display in the Process Editor, select the Mapping box with the right mouse button, and then select Properties.
Enter the column information, until you come to the Column Mapping tab.
Select a column.
Click Derive Mapping.
Enter the derived mapping information (transformation details).

Properties

The following table lists all of the properties for WHCTRNFM and indicates how you can use each property with metadata API methods.

In the table, you can specify properties with a Yes in the Indirect Add column when you indirectly add one object through another, as described in the documentation for the _UPDATE_METADATA_ method. Use this approach to add a new dependent object. For details, see Using _UPDATE_METADATA_.

You can pass properties with a Yes in the Update column to the _UPDATE_METADATA_ method, as described in the documentation for this method. Use this method to update properties of an existing object. For details, see Using _UPDATE_METADATA_.

* Req indicates that the property is required; you must provide a value for this property when you use a given method. * Default indicates that the system will provide a default value for that property if you do not provide one. * Auto supplied means that the property is automatically supplied; any value that you specify for such a property is ignored.

Properties with a Yes in the Read Method Expand Parm column are valid with the expand parameter of the _GET_METADATA_ method. This method enables you to get detailed metadata about a property and its associated objects through a single method call.

Properties	Type	Indirect Add	Update Method	Read Method Expand Parm.
Cvalue	C	Yes	Yes	No
Desc	C	Yes	Yes	No
Extended Attributes	L	Yes	Yes	Yes
Id	C	* Req	* Req	No
Input Objects	L	No	No	No
Input Sources	L	* Req when mapping is one-to-one	Yes	No
Mapping	L	* Auto supplied	No	No
Mapping Type	C	* Req	No	No
Metadata Created	C	No	No	No
Metadata Updated	C	No	No	No
Name	C	* Default	Yes	No
Note	L	Yes	Yes	Yes
NValue	N	Yes	Yes	No
Output Objects	L	No	No	No
Output Targets	L	Yes	Yes	No
Source Code	L	No	No	Yes
Source Text	L	Yes for derived mapping only	Yes for derived mapping only	No

New properties for WHCTRNFM are as follows:

INPUT OBJECTS

specifies an SCL list of general identifying information about the objects that are input to this transformation. Input objects are discussed in INPUT and OUTPUT Properties.

INPUT SOURCES

specifies an SCL list of general identifying information about the objects that are input to this transformation. This list points to the input columns or transforms. If you use a column as the input for a transform, the name of the column's physical table must exist.

Objects are verified to ensure that they are part of the same process. If they are not part of the same process, an error message is produced. Input sources are discussed in INPUT and OUTPUT Properties.

MAPPING

specifies an SCL list of general identifying information about the mapping process to which this transformation belongs.

MAPPING TYPE

indicates the type of column mapping. Possible values are

ONE TO ONE--mappings that do not include any transformations.

DERIVED--mappings that include transformations.

OUTPUT OBJECTS

specifies an SCL list of general identifying information about the objects that are output from this transformation. Output objects are discussed in INPUT and OUTPUT Properties.

OUTPUT TARGETS

specifies an SCL list of general identifying information about the targets that are output from this column. This list points to the output column, transform, or row selection object. Objects are verified to ensure that they are part of the same process. If they are not part of the same process, an error message is produced. Only a single WHCOLUMN subtype object can be specified, while multiple WHROWSEL objects can be included. Output targets are discussed in INPUT and OUTPUT Properties.

SOURCE CODE

specifies an SCL list of general identifying information about the source code for this transformation.

SOURCE TEXT

represents an SCL list of character items. Each item can contain a maximum of 200 characters of source code. You can add or update this property for a derived mapping, but it is ignored for a one-to-one mapping.

Using WHCTRNFM

Add	Update	Delete
No	Yes	Yes

WHCTRNFM is a dependent type. To understand how it relates to other types, see the column mapping models in Relationships Among Metadata Types.

Top of Page