Transformations
Controls transformation naming, relation use, calendar fields, and generated views.
Use this page to find the Transformations settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| Default Calendar Macro | DEFAULT_CALENDAR_MACRO | Not set. | Name of default calendar macro. |
| Trans Alias Alias | TRANS_ALIAS_ALIAS | @thisalias | Alias to use as the current alias name. |
| Trans Column Alias | TRANS_COLUMN_ALIAS | @thiscol | Alias to use as the current column name. |
| Trans Default Use Relations | TRANS_DEFAULT_USE_RELATIONS | 2 | 1 - use business key references rather than hash key references. 2 - use hash key references rather than business key references. 3 - use hash key references only. 4 - use business key references only. |
| Trans Field Alias | TRANS_FIELD_ALIAS | @this | Alias to use as the current field name. |
| Trans Friendly Names As Column Names | TRANS_FRIENDLY_NAMES_AS_COLUMN_NAMES | 1 | Use friendly names as column names in transformations: 0 - No, 1 - Yes. |
| Trans Use No Lock | TRANS_USE_NOLOCK | 1 | Use NOLOCK hint in regular transformations: 0 - No, 1 - Yes. |
| Transformation Calendar Fact Pattern | TRANSFORMATION_CALENDAR_FACT_PATTERN | FK_{TableName}_{ColumnName} | Pattern of calendar fields in transformations. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID}, {TableID} and {ColumnName} placeholders. |
| Transformation Hist ID Pattern | TRANSFORMATION_HIST_ID_PATTERN | FK_{TableName} | Pattern of key fields in transformations. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID}, {TableID} and {ColumnName} placeholders. |
| Transformation Key Null To Zero | TRANSFORMATION_KEY_NULL_TO_ZERO | 1 | Transformation wizard defaults: key fields NULL to zero. 0 - No, 1 - Yes. |
| Transformation Unknown Members | TRANSFORMATION_UNKNOWN_MEMBERS | 1 | Transformation wizard defaults. Create unknown members. 0 - No, 1 - Yes. |
| Transformations Createviews | TRANSFORMATIONS_CREATEVIEWS | 0 | Create VIEW when saving transformation: 2-yes, 1-compile only, 0-no. |
