Using Data Type Mapping Sets
Data type mapping sets contain a list of mappings that are used when loading tables into the data warehouse.
Custom data type mapping sets give you the ability to automatically change the data type of any column or to add column transformations when dragging and dropping new Load tables. These mapping sets can be created, edited, deleted, imported and exported using the Data Type Mappings options from the Tools menu.
In the connection Properties screens, a drop-down list Data Type Mapping Set is displayed. This enables you to specify the default data type mapping set to use when loading tables into the data warehouse.
Data Warehouse Connection Properties
Non-Data Warehouse Connection Properties
The succeeding sections describe how to manage data type mappings in RED.