Data Type Mapping Set
XML files have been created to store mappings from one set of data types to another. Setting this field to "(Default)" will cause Data Warehouse Designer to automatically select the relevant mapping set; otherwise you can choose one of the standard mapping sets from the drop down list or create a new one.
Once the connection has been set up, you can right mouse click the connection in the middle pane and view the properties for that connection.
Database Link Load - Other DB
When running a SQL Server data warehouse it is possible to create database links (linked server) to other SQL Server instances and most of the other major databases such as Oracle, DB2 etc.
When coming to the Data Warehouse from an OLTP source system, the connection defines the path to get to those source tables. A connection object must be defined for each source system.
Database link load - from a table in another database on the same SQL Server instance:
