Generic Transformation Rules
The following transformation rules apply to all types of supported transformations:
A transformation should have only one transformation source schema.
A transformation can have multiple target schemas.
Transformations are always one way. In one transformation, a classifier from the target data store cannot be mapped to any classifier from the source data store.
A source classifier can be mapped to multiple target classifiers in the same transformation.
Classifiers from the same schema cannot be mapped to each other.
Multiple source classifiers can be mapped to the same target classifier in one transformation, but the mappings between the source classifier and the target classifier should be done separately in the ClassifierMap Designer. In other words, multiple instances of the same target classifier should be dragged into the ClassifierMap Designer.
In a transformation, one source feature can be mapped to multiple target features.
In a transformation, if the target feature does not support expressions, then it can only be mapped from one source feature.
A target feature can have an expression even if it is not mapped in a transformation. The expression can be defined using constant values.
Folders (including Key and Non-Key) cannot be mapped in the FeatureMap Designer.
Items under the Keys folder cannot be mapped in the FeatureMap Designer.
Unsupported data types are grayed out in the FeatureMap Designer and cannot be used in a mapping or an expression.
Transformation rules for Enterprise Database Server to SQL Server Transformations
In addition to the general rules, the following rules apply to the transformations from Enterprise Database Server to SQL Server.
In a transformation feature level mapping, multiple source features can be mapped to a single target feature provided an expression is defined.
A Remapped data set of the Enterprise Database Server cannot be the source of a classifier mapping. It cannot be dragged into the ClassifierMap Designer.
Transformation rule for Oracle Database as the Transformation Target
In addition to the general rules, the following rule applies to the transformations for Oracle data store as the transformation target.
External table, Temporary table, Nested table, Varray, XML Type table/column, and REF column objects are not supported.