Apply Data Type Mappings
Determines if the Data Type Mappings that are applied to source tables are used in the Staging and Persistent Staging databases. As the Data Type Mapping function is normally used to accommodate changes in the source this setting should normally be enabled.
When enabled, tables in the Staging, Persistent Staging, Delete Detection, and Landing stages are modeled with the expanded (mapped) data types, and the generated SSIS data flows convert source columns to the mapped types. When disabled, these tables keep the unmapped source data types.
When to Change This Setting
Keep the default Y so the staging layers absorb source data type changes through the Data Type Mappings. Disable it only when the staging tables must mirror the source data types exactly.
Related Settings
| Setting | Interaction |
|---|---|
| Apply Data Type Mappings | Enables the Data Type Mappings function overall |
| Apply Data Type Mapping DV | The equivalent per-layer control for the Data Vault |
Notes
- This setting is part of the Staging settings category.
- The default value for this setting is
Y.